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 Table comparison mode
This mode allows users to compare results or the query execution or procedure call with the database table or view content.
In the synchronization process, the table (at right side) will be modified to query result state.
DTM Data Comparer saves the query associated with the right side table to project file. When the user selects the table with stored query the program restores it.
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 Query comparison mode
- File to Table comparison mode.
- Excel to Table comparison mode.
- Database comparison mode.