Whats the best way to handle updates to my database when that database also contains client information. In hindsight having one db probably wasn't a good idea.

I need to modify the table structures, delete and add information but I don't want to loose any user information in the process.

I need a method that I can use repeatedly.

Any advice appreciated.