Page History
The IDERA SQL Data Compare Unique Keys tab is divided in two main sections. The top section contains two boxes 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 SQL Data Compare found, but you can add other unique keys that can be a combination of any and all the columns 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. SQL Data Compare picks the comparison key in the following order (whichever is found first):
...
When the selected keys are not those that were picked by SQL 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 those tables. By default the keys are only validated for type compatibility. If you wish to validate your custom defined keys for uniqueness then you should check that option in the Application Settings. User-defined key validation is done as follows:
...
| Info |
|---|
User-defined keys are not supported on Memory Tables. |
...
| Excerpt |
|---|
Total compare from data to schema with IDERA SQL Comparison Toolset. Learn more > > |
...