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

See also: