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.
DTM Data Comparer: query to table comparison mode

See also: