Set-up Primary Keys Comparison options

1. Select Comparison Options from Tools main menu.
2. Go to Primary Keys Comparison tab.
3. Use check-boxes to select/unselect comparison options, according to your strategy.

   Understanding Primary Keys Comparison options:

   • Case sensitive comparison – if you select this option, the key and the field name will be compared according to the accurate case. If you omit this option, the case of the key and the field names doesn’t affect the comparison algorithm. [Default value – omitted].
   • Include identical rows in comparison report – if you select this option, identical primary keys will be included in the comparison report. If you omit this option, only different or missing on one side primary keys will be included in the comparison report. [Default value – selected].
   • Include different rows in comparison report – if you select this option, primary keys considered as different will be included in the comparison report. If you omit this option, only identical or existing on one side primary keys will be included in the comparison report. [Default value – selected].
   • Include missing rows in comparison report – if you select this option, primary keys, existing only on one of the sides, will be included in the comparison report. If you omit this option, only primary keys, existing on both sides will be included in the comparison report. [Default value – selected].
   • Compare primary key name – if you select this option, primary key name will be included in the comparison algorithm. If you omit this option, the primary key name will not be a part of the comparison algorithm. [Default value – selected].