February 20, 2011 at 11:41 pm
we have got two sites with same database but one was not updated since a year ago. So how can we compare the schema from two sites and then match the schema for the old database to the new one? Also we don't want to lose the data for the old one.
thanks
February 21, 2011 at 4:26 am
February 21, 2011 at 5:49 am
I would strongly suggest you take a look at SQL Compare[/url] from Red Gate (yes, I work for them). But, you need to know, while SQL Compare works wonders, it's not magic. Depending on the changes that have occurred in your system, it's possible that you will have data breaking changes. You should make a copy of the second database and test this process before you simply run it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply