xSQL Data Compare

Comparison Keys

 

The "Comparison Keys" tab contains two sections - the top section contains a box with the list of unique keys that are potential candidates to be used as the comparison key for each table in the pair. Initially the boxes contain only the predefined unique keys that xSQL Data Compare found, but you can add other unique keys that can be a combination of any and all the fields on the given table. The bottom section contains a box with the pair of unique keys that have been selected as the key to be used for the data comparison operation. Double-clicking on a unique key on the top section will replace the selected key with the new one.

When the selected keys are not those that were picked by xSQL Data Compare you should validate the keys by clicking on the Validate button. If the selected keys are not valid you will not be able to compare the given tables.