Change DataCompare Comparison Key

Automate and integrate using the SQL comparison API

Moderator: Chris Auckland

Change DataCompare Comparison Key

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

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

Postby Brian Donahue » Tue Sep 22, 2009 4: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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests