Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for Cross-DBMS logo for Cross-DBMS
 
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
AccdbMerge 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 views in databases on different DBMS platforms. 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 Schema Changes Summary use case) and click A Batch data diff toolbar button.

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

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

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

    for Cross-DBMS, batch data diff new and changed
  5. Select tables to merge at G and click Merge at H.

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

    for Cross-DBMS, batch data merge configuration
  7. In the opened Execute script dialog, click K Run to apply changes immediately, or use L Copy / Save to store the script for later use.

    for Cross-DBMS, Execute script dialog for batch data merge