|
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 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.
|
