Data Comparison Warnings and Errors

The program shows a few messages about database structure compatibility issues. There are:

DTM Data Comparer: table structure warning   The program shows this message if tables to be compared have a different number of columns and right mapping not specified.
DTM Data Comparer: primary key compatibility warning   The program shows this message if tables to be compared have a different number of columns in the primary key and alternate key structure not specified*.
DTM Data Comparer: no primary key warning   The program shows this message if some table has no organic primary key and no alternate key column was specified.
DTM Data Comparer: data type compatibility warning   The program shows this message if tables have at least one incompatible column pair and correct mapping not specified. This message can be ignored by the user if necessary.
DTM Data Comparer: primary key outside mapping warning   The program shows this message if the table has a mapping but at least one primary key column not included in. The comparison is impossible in this case.

* - the program can use the unique key definition from another side if both objects (table and table, query and table, etc) have same columns.

See also: Collate and Sort Order warning.