DTM Data Comparer 1.25.01

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

Keywords: compare data, compare tables, compare data rows, data synchronization, db comparison, db sync

Click to enlarge

Author:

DTM soft     Other programs by DTM soft

Downloads:

641

Size:

1452K

Cost:

$159.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Demo [?]

Operating Systems:

Release Status:

update (2015-09-06)

Recent Changes:

$TableLeft$ and $TableRight$ macros added for report file name.
$DATE$ and $TIME$ macro format can be changed in the settings.
SQLite and SQLAnywhere support improved.

Supported Languages:

English

Additional Requirements:

ODBC, OLE DB, IDAPI or Oracle Call Interface

AdeptSQL Diff
Database schema difference viewer and synchronization tool for MS SQL Server

DB Explorer
Compare two database schemas and/or table data, report differences and sync.

SQL Server Comparison Expert
Compare and Synchronize mssql Database with SQL Server Comparison Expert.

EMS Data Comparer for Oracle
Powerful and easy-to-use utility for Oracle data comparison and synchronization.

SyncBack4all - File sync backup
Backup and synchronize your important data to PC, network, USB drives, FTP.

EMS Data Comparer for MySQL
Powerful and easy-to-use utility for MySQL data comparison and synchronization.

EMS Data Comparer for SQL Server
Powerful and easy-to-use tool for SQL Server data comparison and synchronization

dbForge Data Compare for SQL Server
SQL Server data comparison and synchronization tool

dbForge Schema Compare for SQL Server
SQL Server database schema comparison and synchronization tool

Altova MapForce Enterprise Edition
Altova MapForce is a graphical data mapping, integration, and ETL tool.

Altova MapForce Professional Edition
Altova DatabaseSpy Enterprise Edition
TextPipe Pro
Events Management Software
dbForge Data Compare for MySQL
dbForge Query Builder for MySQL
dbForge Schema Compare for MySQL
RazorSQL
Visual Importer ETL Enterprise 32 Bit
Database Browser Portable

Advanced ETL Processor 32 Bit (1621 dl.)
Database Tour (1616 dl.)
Database Browser Portable (1600 dl.)
Database Tour Pro (1507 dl.)
Altova DatabaseSpy Enterprise Edition (1413 dl.)
Exportizer Pro (1400 dl.)
Exportizer (1399 dl.)
Visual Importer ETL Standard 32 Bit (1384 dl.)
RazorSQL (1371 dl.)
Altova MapForce Professional Edition (1322 dl.)