Product Home
DTM Data Comparer Online Documentation
General
Product profile
Connect
Key definition
Column mapping
Settings
Project Properties
Syncronization
Command line
Support
Information
License
Demo and Full versions
Install
How to buy
Upgrade
Uninstall
Products
Glossary

Product profile

DTM Data Comparer is a visual tool for data comparison and synchronization. The program successively views the contents of both tables basing on the order of ascending of Primary Key (or unique key) values. If the program cannot find two records with the same key value, it places the records to different lines and highlights in yellow. If values of the keys coincide, the program places them to the same lines and highlights equal fields in green and unequal fields in red. If a field is marked as bold, it is a part of the table primary key or unique key. When you use mapping, the program leaves columns that don't take part in comparison white.

During synchronization, the program makes the contents of the secondary table equal to the contents of the primary one. In this process records absent in the primary table will be deleted from the secondary one, records that differ will be updated, while records absent in the secondary table will be inserted from the primary one.
You can change this behavior using the following options:

  1. Delete from secondary - disabling this option will block deleting a record from the secondary table even if there is no such record in the primary table.
  2. Insert by primary - disabling this option will block adding records from the primary table even if there are no such records in the secondary table.

DTM Data Comparer

Limitations of the current version:

  • the program considers all NULL values equal;
  • this program version does not support working with BLOB completely. It compares their initial fragments only in hexadecimal format. Also, BLOBs synchronization does not supported;
  • the program loads part of tables' contents to memory for comparison and visualization, so there is a restriction on the number of records in the processed tables. It depends on the size of RAM, selected options and the size of record.

DTM Data Comparer is a true Win32 application, known to be compatible with the following operating systems: Windows 98 and ME, Windows 2000 family, Windows XP (Home and Professional), Windows 2003 Server family, Windows Vista. To be able to work with Windows 95 and Windows NT 4.0, you will have to download an additional library set from our site.