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:

677

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

Exportizer Pro
Database export 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

Altova MapForce Enterprise Edition (2129 dl.)
Advanced ETL Processor 32 Bit (1656 dl.)
Database Tour (1653 dl.)
Database Browser Portable (1638 dl.)
Database Tour Pro (1537 dl.)
Altova DatabaseSpy Enterprise Edition (1448 dl.)
Exportizer (1434 dl.)
Visual Importer ETL Standard 32 Bit (1410 dl.)
RazorSQL (1400 dl.)
Altova MapForce Professional Edition (1356 dl.)