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

Table to Table Mode User Interface

In this mode program's window has two zones: primary and secondary. In each zone the user can specify table and where clause, if necessary.
Also, each zone has data grid that shows table content or comparison results.

Information line is located at the bottom of the window. It allows the user to view:

  • Number of rows in the table, when data grid is populated by data rows.
  • Primary key size (number of columns in the key).
  • Number of mapped columns.
  • Number of columns in the table.

Last three values united to one information panel like: 5/40/50.

"Where" option allows the user to limit rows to be compared or synchronized. The clause should be entered without "where" keyword, example: ID <1000

The comparison indicator between data grids shows number of equal, different and orphaned rows: DTM Data Comparer: row indicator

"Show data" option is a fast way to review table content. The small box near "show data" button contains number of rows in the table with specified WHERE clause consideration.

DTM Data Comparer: main window

If a field is marked as bold, it is a part of the table primary key or unique key.