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

Table structure diff tab

  • Opened from: Object list and Find tabs
  • Applicable tab-specific toolbar actions:
    • Jump to the next, previous change
    • Merge left selected records to the right side, right selected records to the left side
    • Delete selected records on the right side, selected records on the right side
    • Export to Excel
  • Applicable object types: Tables

This tab allows to compare definition of particular table:

Tab is splinted into 3 major sections: fields, indexes and relationships. For linked tables it also shows fourth section at the top with linked table connection parameters: Connect and SourceTableName.

If 'Load field properties' option is enabled in Settings dialog, then this tab shows field properties like Format, DecimalPlaces and so on, allows to merge fields and/or their properties.

Free version limitations:

  • Shows only fields, without field properties, indexes and relationships are not shown
  • Field merge is not allowed
  • No Excel export
  • No jump to the next/revious change

Last updated: 2019-07-04