sql server update multiple db's without losing data

ICPooreman
ICPooreman used Ask the Experts™
on
So I have deployed a few applications to a few different clients while I'm still doing development on the project.  Usually there's not a lot but there's some table structure changes to the baseline db along with some stored procedures changing/being added.

I don't want to lose any of the data in the databases that are deployed.  Basically I want to write a script that will eithe move the data from the old database used by the client into the updated baseline version.  Or write a script that will update the structure and stored procedures of the old database used by the client with the new baseline version.

Just looking for advice on the easiest way to do something like this.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2008
Awarded 2008
Commented:
First, back all of your databases up to disk.  Then, define which objects/tables needed to be modified.  Then, go to www.red-gate.com and download their toolkit.  There is a SQL Data Compare tool that will allow you to sync the data and a SQL Compare tool that will allow you to sync the schema.  Will make life a LOT easier.

Author

Commented:
Thanks, after searching around and taking your advice into account that really does appear to be the best option as far as I can tell.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial