Change DataCompare Comparison Key
Rawden
Posts: 34 Bronze 2
Hi,
In SQL Data Compare, you have the option of changing the Comparision Key from the primary key to something else.
I'm just looking for some help to enable me to do this in the SDK.
Would I still create the mappings:
dbMappings.CreateMappings(dbSource.Tables, dbDest.Tables)
and then change the key afterwards, or would I change this to something else?
In SQL Data Compare, you have the option of changing the Comparision Key from the primary key to something else.
I'm just looking for some help to enable me to do this in the SDK.
Would I still create the mappings:
dbMappings.CreateMappings(dbSource.Tables, dbDest.Tables)
and then change the key afterwards, or would I change this to something else?
Comments
Using the SDK, you can use the automatically-created mappings as a starting point and modify them by setting MatchingMappings, or you can create the table and column mappings from scratch. The following examples illustrate these:
Modifying automatically-created mappings
Creating mappings manually