DTM Data Comparer is a visual tool for data comparison and synchronization.
There are five comparison and synchronization modes:

• Table to table.
• Query to table.
• Query to query.
• File to table.
• Excel to table.
• Database.

In the first block of modes, the user can compare two tables, query results with table, results of two queries execution, text file and Excel spreadsheet with the table. There are more flexible and allow users to:

• Specify custom unique key columns instead of the primary key.
• Define column mapping.
• Compare or synchronize only part of the table by WHERE clause specification.

In the last (database) mode, the program compares more than one pair of tables per project. Only default settings can be used in this case: native primary keys, no mapping, etc.

The user can select comparison mode clicking the related tab at the main window of the comparison tool. The program creates a new projects in the table to table mode by default. Please refer to setting window to change this behavior.

DTM Data Comparer is a Win32 application that compatible with the following operating systems: Windows XP, Windows 2003/2008/2012 Server family and Windows Vista, 7, 8/10 (desktop). The 64-bit edition is also available.

See also

• How does the tool compare data?
• How does the tool synchronize data?
• Product limitations.