Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
AccdbMerge logo for MS Access
aka AccdbMerge
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for SQLite logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license
Other tools

Compare and Synchronize Table Definition

This section covers comparing and synchronizing table definitions — columns, indexes, and data macros. It does not include data. For example, if you create a missing table or column, it will be empty. To copy data, see the Diff & Merge Table Data use case.

Table schema handling is covered in two ways:

  • Full-table sync: work with table lists and synchronize entire tables.
  • Granular changes: analyze changes in a specific table and apply only selected differences.

Most of the synchronization steps in these use cases require the Standard version. However, you can still compare databases and view schema differences in the Free version.

Compare and Sync Multiple Tables

  1. Make sure the Load load field properties option enabled: A click Settings, B enable this option if it is disabled, and C click OK.

    for MS Access, Settings, Load field properties
  2. Open databases (see the Project Changes Summary use case) and click D NEW+CHG (new + changed) count for Table definitions. Or, you can click other counts to process all, only new or only changed table definitions.

    for MS Access, Home tab with project changes summary, click NEW+CHG
  3. Opened Object list tab contains list of all changed table definitions and tables entirely missing in the other database. Use filter E to show only new or only changed objects. The header shows F total counts, and the footer shows G text preview of the object definition changes.

    for MS Access, Object list tab with new and changed tables
  4. To synchronize changes, H select required tables, click I Merge, and J click OK in the opened confirmation dialog.

    for MS Access, Object list tab with tables - select and merge
  5. Wait for K progress completion.

    for MS Access, Object list merge - wait for completion
  6. Now we can verify that our objects are merged - they are missing in our New and changed list, L NEW+CHG total count updated respectively.

    for MS Access, Object list - merged objects removed from New and Changed
  7. Click M Show all to ensure that processed objects exist in both databases with the same definition.

    for MS Access, Object list - merged objects have the same definition in both databases

Compare and Sync Specific Table Changes

  1. Make sure the Load load field properties option enabled: A click Settings, B enable this option if it is disabled, and C click OK.

    for MS Access, Settings, Load field properties
  2. Open databases (see the Project Changes Summary use case) and click D CHANGED count for Table definitions.

    for MS Access, Home tab with project changes summary, click CHANGED
  3. Opened Object list tab contains list of all changed table definitions. Click E on required table name to analyze specific table definition changes in detail.

    for MS Access, Object list tab with changed tables
  4. Opened Table structure diff tab contains detailed information about table definition changes. New and changed items (columns, indexes, data macros) and specific changed attributes are highlighted. Click F to select items you want to merge, then G Merge, and H OK in the opened confirmation dialog.

    for MS Access, Table structure diff tab
  5. Wait for I progress completion.

    for MS Access, Table structure diff tab - merge progress
  6. After progress completion required changes are synchronized.

    for MS Access, Table structure diff tab - merged items have the same definition