| 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:
- 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.
- 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.
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 XP,
Windows 2003/2008 Server family and Windows Vista/7. |
