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 Database Programming Objects

This section covers comparing and synchronizing database schema objects other than tables — queries, modules, forms, etc. Some features related to detailed diff analysis are available only for the Standard version.

Object handling is covered in two ways:

  • Bulk sync: work with object lists and synchronize multiple objects at once.
  • Detailed comparison: analyze changes in a specific object without synchronization.

Compare and Sync Multiple Objects

  1. Open databases (see the Project Changes Summary use case) and click A NEW+CHG (new + changed) count for required object type, for example for Modules. Or, you can click other counts to process all, only new or only changed objects.

    for MS Access, Home tab with schema changes summary, click modules NEW+CHG
  2. Opened Object list tab contains list of all changed objects and objects missing in the other database. Use filter B to show only new or only changed objects. The header shows C total counts, and the footer shows D text preview of the object definition changes.

    for MS Access, Object list tab with new and changed modules
  3. To synchronize changes, E select required objects, click F Merge, and G click OK in the opened confirmation dialog.

    for MS Access, Object list tab with modules - select and merge
  4. Wait for H progress completion.

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

    for MS Access, Object list - merged objects removed from New and Changed
  6. Click J 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 Specific Object

  1. Open databases (see the Project Changes Summary use case) and click A CHANGED count for required object type, for example for Modules.

    for MS Access, Home tab with schema changes summary, click modules CHANGED
  2. Opened Object list tab contains list of all changed objects. Click B on required object name to analyze specific object changes in detail.

    for MS Access, Object list tab with changed modules
  3. Opened Text diff tab contains object definition texts from both databases. C New and changed lines are highlighted. Bottom of the screen contains D detailed comparison for selected line.

    for MS Access, Text diff tab with a changed module
  4. You can click E Show only new and changed to collapse unchanged lines, or apply similar filter to show only new or only changed lines. Unchanged lines are collapsed, leaving just a few unchanged rows for context, which can be configured F.

    for MS Access, Text diff tab with a changed module, show new and changed