Set a custom comparison key?

ATimson

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.

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();