DTM Data Comparer is a data comparison and synchronization software. It was designed and developed to help database users to compare or synchronize MySQL databases and other database types. The tool offers both visual and console (unattended) modes of comparison and synchronization. All modern versions of MySQL Servers are supported: DTM Data Comparer uses unified interface (ODBC or OLE DB) to access data rows.
The software fetches MySQL tables and compares primary key values. Of course, the user allowed defining alternate unique key if the table has no PK. If the table has no rows with the same key value, the software places the records to different data grid lines and marks row by the yellow background. If the key values are equal the program places them to the same grid lines and marks cells for equal fields by green background and different fields by red.
The important DTM Data Comparer feature is tables with different structure comparison: mapping allows users to assign correspondence between source and target columns. The user can also apply built-in database functions like CAST to destination value. It is suitable for complex comparison for different data types.