Factors for comparison key?
msandico
Posts: 9
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?
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?
Comments
- 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
Product Support
Red Gate Software