Data comparision bewteen db's with different schemas

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Data comparision bewteen db's with different schemas

Postby Cymru_Chris » Wed Oct 03, 2012 9:54 am

Hi all,

I'm working on an upgrade project that requires me to generate a data comparsion between 2 databases. The 2nd database is a upgrade of the first and I'm thinking of using Redgate compare to achieve this.

It's very convoluted but my simple question is this: Is it possible to use data compare to generate difference between db's with different schemas? (Only columns are added - I can't see any that have been deleted as yet).

Any advice/help appreciated.

Cheers.

Chris.
Cymru_Chris
 
Posts: 1
Joined: Wed Oct 03, 2012 9:40 am

Postby Chris.Allen » Wed Oct 03, 2012 12:26 pm

I'm not an expert but I'm about 90% confident that you would have to ensure that the schemas are synchronized first (for example, by using SQL Compare first). I think there is some latitude for difference- for example as long as the columns allow nulls and have no constraints etc it may well work.

Give it a try, won't cost any monies :)
Chris.Allen
 
Posts: 594
Joined: Thu Mar 12, 2009 4:17 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest