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

Batch data diff tab

  • Opened from: Batch data diff toolbar action (Ctrl+Shift+B keyboard shortcut) and from Home tab
  • Applicable tab-specific toolbar actions:
    • Export to Excel
    • Show all, new and changed, new, changed
    • Jump to the next, previous change
    • Select all, none, invert selection on the left, all, none, invert selection on the right: selection can be changed using any of left or right selection buttons
  • Applicable object types: Tables and Views

This tab allows to compare data for multiple tables and views, providing summary of data changes for the whole database:

Top panel contains:

  • Run action, which also available by F5 keyboard shortcut
  • a number of self-descriptive execution options which are available with Alt and action key from keyboard. Action key is underlined when you hit the Alt key. So, for example Alt+V shortcut switches 'Show views' option
  • quick filter button that allows to filter object list by name. This can be very convenient for large object lists. This action also available with Alt+F keyboard shortcut

Result columns:

  • Table name - name of the table or view
  • Type - table or view
  • Changed columns - this table in left and right projects has different columns. Why this important - even if it shows 0 changes, this result is based only on common columns. Columns whih exist in only one side - they still may have some data missing in the other side and this is not counted as change
  • Common key - table has compatible primary key on both sides, which consists of the same columns with the same data type. Common primay key is required to compare data, without it only total record count can be calculated. Key also can be defined in the diff profile, not only for tables but also for views
  • Total (left) and Total (right) - total record count
  • New (left) and New (right) - new record count. Can be сalculated for all tables and for views with a key defined in the diff profile
  • Changed - changd record count, calcalated only for common table columns (which exists in both sides). Can be сalculated for all tables and for views with a key defined in the diff profile
  • Error - result calculation error, if any, may help to understand what was wrong (for example - timeout or missing permissions) and how this can be fixed

Tables without common key are compared just by row number.

Totals values are highlighted in red if they are different (so, changed records should not produce Total highlight). Changed records are also highlighted as red if Changed > 0. Unlike Total and New there is no Changed left and right, it is just a single value because if some record is changed then this change should be counted as +1 for both sides. New value is highlighted in green if it is > 0.

Free version limitations:

  • The whole tab is not available

Last updated: 2022-05-23