DTM Data Comparer 1.09.18

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 comparision, db sync

Click to enlarge

Author:

DTM soft     Other programs by DTM soft

Downloads:

15

Size:

1111K

Cost:

$159.00 US

Users Rating:

    Reviews (0)     Write review

Feedback:

Report broken download     Report spyware [?]

License:

Demo [?]

Operating Systems:

Release Status:

update (2012-02-08)

Recent Changes:

Better support for collations (SQL Server, Oracle, MySQL, PostgreSQL 9).
Table list refresh feature.
GUID conversion feature.
Better support for national strings comparison.

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.

xSQL Object
Compare and synchronize sql server databases - SQL Server 2000/2005/2008/2008R2

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

dbForge Data Compare for MySQL
A tool to compare and synchronize data of MySQL databases.

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 database comparison and synchronization tool

DBDocumentor
Produce cross referenced and hyperlinked documentation of SQL databases.

ETL-Tools QlikView Connector
Universal SQL Editor
Reportizer
Visual Importer ETL Standard
Small Library Organizer Pro
MyDbExplorer
FlowHeater
Advanced XLS Converter
SQLite Developer
ESF Database Migration Toolkit Standard

Advanced XML Converter (361 dl.)
CDBF for Windows (351 dl.)
Export Table to Excel for SQL Server (336 dl.)
BBAutoHarvest (329 dl.)
Data Exchange Wizard (305 dl.)
Database Oasis (297 dl.)
Visual Importer ETL Standard (295 dl.)
Export Schema to SQL for SQL Server (287 dl.)
FmPro Script Diff (282 dl.)
EMS Data Import for Oracle (281 dl.)