CODEWITHSUNDEEP
sqlsql-server
Buddhika Ariyaratne
Buddhika Ariyaratne

Reputation: 2423

Update SQL Server database schema

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?

Upvotes: 0

Views: 371

Answers (1)

Lynn Crumbling
Lynn Crumbling

Reputation: 13357

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.

Upvotes: 1

Related Questions