Factors for comparison key?

msandico

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?

Manfred.Castro

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