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

Data Changes Summary

In this use case, we summarize data differences across multiple tables or queries in two MS Access databases. You’ll get total, new, and changed row counts per object. After analysis, you can merge selected changes. This feature is available only in the Standard version.

  1. Open databases (see the Project Changes Summary use case) and click A Batch data diff toolbar button.

    for MS Access, Home tab with schema changes summary, click Batch data diff
  2. Specify B calculation type, C whether to process tables or queries (or both), and D click Run.

    for MS Access, batch data diff set up options
  3. Wait for progress to complete — you'll see the result at E.

    for MS Access, batch data diff ready
  4. Click Show only new and changed at F to filter and display only objects with data differences.

    for MS Access, batch data diff new and changed
  5. Select tables to merge at G and click Merge at H.

    for MS Access, batch data diff - select tables and merge
  6. In the opened merge configuration dialog, specify I Scope and data options, review other settings, and click OK at J.

    for MS Access, batch data merge configuration
  7. After merge completion K row counts updated, demonstrating successful merge result. Tables that no longer have any changes corresponding to the current New and Changed filter - excluded from the result (like Order Details)

    for MS Access, batch data merge result