Product Home
DTM Data Comparer Online Documentation Prev Page Prev Page
General
Product profile
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Comparison
Synchronization
Table to Table Mode
Synchronous Navigation
Face-to-Face View
Database Mode
Key Definition
Column Mapping
Settings
General Settings
User Interface
Comparison Settings
Synchronization Settings
Report Settings
Project Properties
Script Viewer
Command Line
Console Mode
Process Cancellation
Comparison Report
Collate Window
Run SQL statement
SQL Console
Hot Keys
Information
Limitations
Support
License
Demo and Full versions
Install
How to buy
Upgrade
Uninstall
Products
Trademark Information
Glossary

Product profile

DTM Data Comparer is a visual tool for data comparison and synchronization. How does the tool compare data and synchronize data?

There are two comparison and synchronization modes: table to table and database. In the first mode the user can compare two tables only. However this more is most flexible. It allows to:

  • Specify custom unique key columns instead of primary key.
  • Define column mapping.
  • Compare or synchronize only part of table by WHERE clause specification.

In the database mode the program compares more than one pair of tables per project. Only default settings can be used in this case: native primary keys, no mapping.

The user can select comparison mode clicking related tab at the main window of the comparison tool. By default the program starts in table to table mode. Please refer to setting window to change this behavior.

DTM Data Comparer is a true Win32 application, known to be compatible with the following operating systems: Windows XP, Windows 2003/2008 Server family and Windows Vista/7. Default downloadable version is ANSI. The unicode version and x64 version are available upon request for registered users.

See also: product limitations.