The Comparison Options section of the Options dialog box displays the options that are used for string-based comparison.
You can choose from among two comparison modes: native type or as string. The native type considers the data type of the column that is compared, whereas everything will be converted into strings before comparison if you use the string representation type.
Clear the Ignore case in comparison check box if upper and lower casing should not be ignored when checking for differences. Select the Ignore whitespaces in comparison option if you do not want to consider whitespaces when comparing database data. Whitespace characters are space, tab, carriage return, and line feed. If you do not want to make a difference between an empty field and a field containing the NULL value, select the Treat [NULL] as empty string check box.
Floating point numbers can be filled up with trailing zeros by selecting the Append trailing zeros to floating point numbers check box.
If you do not care to see rows that are equal in both tables of a comparison, select the Keep only different rows in memory check box. In this case, only different rows are retrieved and displayed in the Result window.
You can define whether you want to process comparison of multiple tables sequentially or parallel. Changes can be committed with or without the use of transactions and you can decide whether or not you want to rollback on errors.
© 2019 Altova GmbH