How can we help you today? How can we help you today?

Set a custom comparison key?

The SQL Data Compare UI lets you set a custom comparison key between two tables. Is there any way to do that from the API's TableMapping class?

I'm not seeing anything relevant, but hopefully I'm just missing something. :smile:
ATimson
0

Comments

1 comment

Sort by
  • ATimson
    Found the answer. (It's in the SQL Data Comparison SDK samples, which I couldn't actually find a working link to. I had to find the SQL Comparison SDK samples link, and change the URL!)

    tableMapping.MatchingMappings.Clear();
    tableMapping.MatchingMappings.Add(mapping.FieldMappings["FieldName"]);
    tableMapping.RefreshMappingStatus();
    ATimson
    0

Add comment

Please sign in to leave a comment.