How do I programatically set the keys of a table in Data Com

ben_leah

How do I programatically set the keys of a table in Data Compare if the tables do not have any keys on them?

ben_leah

In other words, how do set a Comparison Key programatically ?

Brian Donahue

Hello Ben,

There is an example of this in the Toolkit Example files (tablemappingexample.cs)

// Create the mappings between a certain table
				TableMapping tableMapping = (TableMapping)mappings.Join(db1.Tables["[dbo].[WidgetPrices]"], db2.Tables["[dbo].[WidgetPrices]"]);

				// Set the custom comparison key for the table
				tableMapping.MatchingMappings.Clear();
				tableMapping.MatchingMappings.Add(tableMapping.FieldMappings["WidgetID"]);
				tableMapping.RefreshMappingStatus();

ben_leah

Ok, thats fine how do I then just select one other column to do the comparison on. So I only want Updates to be scripted out if only one columns has different values?

Brian Donahue

Hello Ben,

Then you'll want to set the 'include' property to true on the FieldMapping objects for the Fields that you want to compare and false for the ones you don't want to compare. Each TableMapping object in tableMappings should have a FieldMappings collection.