Set-up Data Comparison options

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

   Understanding Data Comparison options:

   • Case sensitive comparison – if you select this option, all the strings in your tables’ data will be compared according to its case. If you omit this option, strings like "AAA" and "aaa" will be assumed as identical. [Default value – omitted].
   • Include identical rows in comparison result – if you select this option, all identical rows will be included in the comparison report. If you omit this option, the report will contain only rows with differences. [Default values – selected].
   • Include different rows in comparison result – if you select this option, all the rows with differences will be included in the comparison report. If you omit this option, only identical and missed (in one side) rows will be included in the comparison report. [Default value – selected].
   • Include missed rows in comparison result – if you select this option, all rows missed on one of the sides will be included in the comparison report. If you omit this option, only rows existing on both sides will be included in the comparison report. [Default value – selected].
   • Ignore leading white space characters during comparison – if you select this option, white spaces existing before the actual string value will be ignored. For example, values " abc" and "abc" will be considered as identical. If you omit this option, all characters in the string will be compared. This property may be best described as "left trim". [Default value – omitted].
   • Ignore trailing white space characters during comparison – if you select this option, white spaces existing after the actual string value will be ignored. For example, values "abc "and "abc" will be considered identical. If you omit this option, all characters will be compared. This property may be best described as "right trim". [Default value – omitted].
   • Ignore milliseconds during comparison – if you select this option, only the part of Hour:Minutes:Seconds of the time data type will be used in comparison process. If you omit this option, the full Hour:Minutes:Seconds:Milliseconds structure of time data type will be used in comparison process. [Default value – selected].
   • Ignore seconds during comparison – if you select this option, only the part of Hour:Minutes of the time data type will be used in comparison process. If you omit this option, the full Hour:Minutes:Seconds structure of time data type will be used in comparison process. [Default value – omitted].
   • Ignore distinction of the [Null] and EMPTY values during comparison – if you select this option, [Null] value and EMPTY value will be considered as identical. If you omit this option, [Null] and EMPTY values will be considered as different values. [Default value – omitted].
   • Ignore distinction of the [Null] and 0 values during comparison – if you select this option, [Null] value and 0 will be considered as identical values. If you omit this option, [Null] value and 0 will be considered as different values. [Default value – selected].
   • Automatic sort – if you select this option, the comparison algorithm will start from automatic table sorting according to unique index (index fields will be used in Order By SQL clause). If you omit this option, table’s records will not be sorted. [Default value – selected].
   • Use ROWID for row identification – (this parameter is relevant only for Oracle databases) - if you select this option, synchronization script contain ROWID values in Where SQL clause. If you omit this option, synchronization script will not contain ROWID field. If you are using Synchronization after the comparison, it’s recommended to select this option. If you plan to create Synchronization script and use it later on other databases – it’s recommended to omit this option. [Default value – omitted].
   • Ignore difference if its value is less than specified one – if you select this option, you can specify the value for minimal difference you are interesting on. If you omit this option, full data value will be compared. [Default value – omitted].
4. Specify comparing behavior for special values:
   • Consider as TRUE value – select value from the combo-box, to be used as "TRUE" value in comparison. This option is useful, comparing Boolean field with regular numeric or string field.
   • Consider as FALSE value – select value from the combo-box, to be used as "FALSE" value in comparison. This option is useful, comparing Boolean field with regular numeric or string field.
   • Default for invisible chars – if your database contains characters, which can’t be displayed with your MS Windows character encoding, those characters will be shown according to character selected from this combo-box. Actual data will not be affected with this character. This parameter affects only windows view interpretation.