KS DB Merge Tools
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
for SQLite

Query key columns dialog

This dialog is opened to specify key columns for the data diff for views and query result diff:

It shows list of all columns from both sides which have the same name and data type. You must select one or more columns and value combinations of these columns must be unique across all records on each side.

This dialog is shown in the following cases:

  • From the Object list tab opened for views, when you click on data diff actions or for a given view
  • From the Text diff tab opened for some view, when you click on data diff actions or
  • From the Query result diff tab when you choose Basic key column mapping option

Free version limitations:

  • The whole dialog is not available

Last updated: 2021-02-09