Factors for comparison key?

Compares and synchronizes SQL database content.

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

Factors for comparison key?

Postby msandico » Fri Jun 14, 2013 4:50 pm

Hi All,

I'm comparing 2 dbs (1 SQL 200R2, 1 SQL 2008) and the 2008 one has been created using SQL Compare from the 2008 R2 one.

Now i am trying to do a Data Compare so it can deploy all the data from 2008 R2 to the 2008 empty database.

However, 128 of the tables could not be compared and this is because the comparison key was not set automatically by SQL Data Compare. Why is this? Do i need to map these manually? Is there a better way?
msandico
 
Posts: 6
Joined: Thu Aug 16, 2012 3:12 pm

Postby Manfred.Castro » Fri Jun 14, 2013 5:30 pm

To match rows in the two data sources, SQL Data Compare requires:

- a comparison key for each table or view
- mappings between objects in the data sources

SQL Data Compare looks for a matching primary key or other unique identifier in each data source to use as the comparison key. This enables matching rows to be identified, and their differences to be compared.

If there is no matching primary key or other unique identifier in each data source, you will need to manually set the comparison key. This article provides information on manually setting comparison keys.

http://documentation.red-gate.com/displ ... arisonkeys
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests