Table of Content
- General
- Product profile
- Connect
- Comparison
- Warnings
- Synchronization
- Table to Table Mode
- Query to Table Mode
- Query to Query Mode
- File to Table Mode
- File to Table, Fixed width
- Excel to Table Mode
- Database Mode
- Synchronous Navigation
- Face-to-Face View
- Key Definition
- Column Mapping
- Settings
- Project Properties
- Script Viewer
- Command Line
- Console Mode
- Process Cancellation
- Comparison Report
- Report Customization
- Collate Window
- Table List Menu
- Run SQL statement
- SQL Console
- Hot Keys
- Information
Query to Query comparison mode
This mode allows users to compare results or the query execution or procedure call with results of another SQL statement execution.
This mode does not support synchronization, the comparison process is only available.
DTM Data Comparer saves both queries to project file.
Important notes
- Unique key for query must be entered manually by the user. Otherwise, the program will try to take it from the secondary table.
- In most cases, the user has to enter ORDER BY clause manually for compatible sort order. We recommend using the unique key as order columns.
See also:
- Table to Table comparison mode.
- Query to Table comparison mode.
- File to Table comparison mode.
- Excel to Table comparison mode.
- Database comparison mode.