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:

Best Answer

  • ATimsonATimson Posts: 15 Bronze 1
    Accepted Answer
    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();
Sign In or Register to comment.