KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for MySQL logo for MySQL
and MariaDB
KS DB Merge Tools for Oracle logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

Custom data diff dialog

This dialog is opened using Custom data diff toolbar action and allows to specify custom column mappings for keys and comparable columns:

for MySQL, custom data diff dialog

This dialog is also opened with Column mapping action from Data diff and Query result diff tab. For Query result diff this dialog is also opened when you specify Customize key & data column mapping option. In both Data diff and Query result diff this dialog is opened without Left table / Right table at the top because it is already defined by application usage context: for Data diff you process some concrete table/view, for Query result diff you have already defined arbitrary query text.

At least one mapping item must be specified as a Key and this column (or column combination) must be unique across all rows on each side.

Option Save to diff profile to use by default is available if the Home tab has loaded diff profile, both DBs are loaded, and the dialog is opened in one of two ways:

  • using Custom data diff toolbar action and left and right table/view is the same
  • using Column mapping from the Data diff tab

Free version limitations:

  • The whole dialog is not available

Last updated: 2023-10-04