KS DB Merge Tools logo KS DB Merge Tools
Documentation
AccdbMerge logo for MS Access
aka AccdbMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
KS DB Merge Tools for Cross-DBMS logo

Table structure diff tab

  • Opened from: Object list and Data diff tabs
  • Applicable tab-specific toolbar actions:
    • Export to Excel
    • Jump to the next, previous change
    • Select all, none, invert selection on the left, all, none, invert selection on the right side
    • Merge left selected items to the right side, right selected items to the left side
    • Delete selected items on the right side, selected items on the right side
  • Applicable object types: Tables

This tab allows to compare definition of particular table:

for MS Access, table structure diff tab annotated

Tab is divided into 6 major collapsible sections (Linked table, Fields, Indexes, Data macros, Parent relations and Сhild relations) and bottom panel for selected item details. Here is explanation of changes highlight annotation on the above screenshot:

  • 1 Changed item (`Invoice Date` which has changed Format)
  • 2 New item (`Comment` field on the right, Order ID index on the left)
  • 3 Unchanged field with changed display order (`Amount Due`)
  • 4 Changed field with changed display order (`Due Date` has changed Format)

Vertical toolbar between two panels contains additional tab-specific actions:

  • Open data diff for the current table
  • Open data diff for the current table filtered only to new and changed records
  • opens query result diff with select top 1000 records statement for this table

Field properties are shown and field merge/delete actions are available only if the 'Load field properties' option is enabled in Settings dialog.

PrimaryKey value in the Fields grid just indicates that this field participates in the Primary index. It can't be merged with a field, only by merging that primary index.

Free version limitations:

  • The whole tab is not available

Last updated: 2023-09-21