 |
| ||||
DTM Data Comparer is a visual software designed for data compare 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 DTM Data Comparer 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. When you use mapping, the program leaves columns that don't take part in comparison white.
During synchronization, DTM Data Comparer 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.
· "Mapping" feature allows comparing two tables that have different structure (number and name of fields).
During synchronization the program creates a set of insert, update and delete statements for data synchronization. The user can select the necessary statements or forbid the unnecessary ones in a special dialog box.
Here are some key features of "DTM Data Comparer":
· Compares two tables in the same or in the different data sources.
· Visual comparison pr ocess and comparison HTML-report make data compare more friendly.
· Mapping feature helps you to compare tables with different data structures.
· Database independent. You can compare one table in Oracle database with table in MySQL as well as Interbase table with table in DB2 database. DTM Data Comparer supports all common database interfaces: ODBC, IDAPI, OLE DB, or even Oracle Call Interface.
Requirements:
· ODBC, IDAPI or Oracle Call Interface
Limitations:
· Demo version allows user to compare only top 6 rows of tables.
· Demo version produces synchronization script for first 6 differences only.
· SQL console partially replaces result values to DEMO string.
· Nag Screen
What's New i n This Release: [ read full changelog ]
· "Ignore quotation" comparison option
· New table list context menu
· Data type compatibility check was added
· Import and Export settings feature
Via: DTM Data Comparer 1.10.00
