Option | Description | Default |
---|---|---|
Field size to be compared* | The program compares only first N specified bytes of long string and text objects | 8192 |
Trim right spaces | The program considers values like "1 " and "1" as equal if this option is switched on | No |
Ignore quotation | If this option is switched on the program considers 'abc' and abc strings as the same value. | No |
Null values are not identical | If this option is turned on the program consider any NULL as unique value that not equals another NULL value | No |
Empty string equals NULL | The program considers empty string equals NULL if this option is switched on | No |
Show different rows only | It allows you to see only different records during compare or synchronization. This option can save a bit of memory for large tables compare. | No |
Show warning for large table | The program recommends changing visualization mode if the option is switched on for large tables | On |
Disable collation coordination | The program disables collation and sort mode coordination feature if this option is switched on | Off |
Use same Where for secondary* | If the option is switched on the program applies WHERE clause from the left side to right side automatically | No |
Create SCHEMA.INI | The user have to switch this option off for fixed width files only. | On |
Apply conversion expression | The program will apply conversion expression from mapping if this option is switched on. Otherwise, conversion will be used for synchronization only. | Off |
Show 'order by' warning | The data comparison software will show warning id query contains no 'order by' clause that required for correct comparison. | Yes |
Color schema | This option allows the user to change data** grid background colors for equal, different and orphaned rows* | Red, Green and Yellow |
* - option requires the program reload.
** - to change color for HTML report the user have to modify CSS in "head.html" file.