Update SQL Server database schema

Question

There is an old SQL Server database which needed to be upgraded to much improved version of database schema. Mostly new columns have been added to existing tables. It is necessary to keep original data in the old database. It there any easy way to upgrade the schema than compacting and updating table by table manually?

try to "alter" as many fields as possible. then delete the old fields and add the new ones. other solution: create a new table and write a php script witch copies the old datas in the new table. — roman
– roman, Commented Apr 1, 2013 at 14:52
There are many solutions to this that prevent you from re-inventing the wheel. — Aaron Bertrand
– Aaron Bertrand, Commented Apr 1, 2013 at 15:13

Lynn Crumbling · Accepted Answer · 2013-04-01 14:51:43Z

1

I've used Adept SQL in the past with a lot of success. It will compare the databases for you, and even generate a script to bring one database up the other. It is not a free product, but you can use it for a trial (with most features, I believe.) If this is a one-time operation, it'll be just what you need.

In the interest of full disclosure, we liked the product so much that we did end up purchasing it.

answered Apr 1, 2013 at 14:51

Lynn Crumbling

13.4k8 gold badges61 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Buddhika Ariyaratne Over a year ago

Thank you very much. I will try it and I will post here the feedback.

Collectives™ on Stack Overflow

Update SQL Server database schema

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related