Change DataCompare Comparison Key

Automate and integrate using the SQL comparison API

Change DataCompare Comparison Key

Postby Rawden » Mon Sep 21, 2009 10:33 am


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?
Posts: 27
Joined: Tue Nov 07, 2006 1:07 pm

Postby Brian Donahue » Tue Sep 22, 2009 3:22 pm

Hi Rawden,

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
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests