Red Gate forums :: View topic - Data comparision bewteen db's with different schemas
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Data comparision bewteen db's with different schemas

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Cymru_Chris



Joined: 03 Oct 2012
Posts: 1

PostPosted: Wed Oct 03, 2012 9:54 am    Post subject: Data comparision bewteen db's with different schemas Reply with quote

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.
Back to top
View user's profile Send private message
Chris.Allen



Joined: 12 Mar 2009
Posts: 585

PostPosted: Wed Oct 03, 2012 12:26 pm    Post subject: Reply with quote

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 Smile
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group