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