Assigning Comparision Key

Compares and synchronizes SQL database content.

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

Assigning Comparision Key

Postby pneema » Fri Jun 29, 2012 8:57 pm

I need to compare 2 databases using Red Gate Data Compare Tool. I just want to confirm that when I will assign Comparision Key in the Data Compare Tool, it will not make any change in the original Databases. I am assuming that it will not update original database but just want to get confirmation.
pneema
 
Posts: 1
Joined: Fri Jun 29, 2012 8:46 pm

Postby chriskelly » Fri Jul 06, 2012 7:40 pm

We have already discussed this as part of a support ticket, but I thought that i would post a reply for other users.

The assignment of a Custom Comparison Key, for example when there isn't a primary key available to use automatically, will in no way change the database schema. It only applies to the SQL Data Compare project.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests