Set-up Foreign Keys Comparison options

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

   Understanding Foreign Keys Comparison options:

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