In this use case, we summarize data differences across multiple tables or views in two SQLite 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.
Open databases (see the Schema Changes Summary use case) and click A Batch data diff toolbar button.
Specify B calculation type, C whether to process tables or views (or both), and D click Run.
Wait for progress to complete — you'll see the result at E.
Click Show only new and changed at F to filter and display only objects with data differences.
Select tables to merge at G and click Merge at H.
In the opened merge configuration dialog, specify I Scope and script options, review other settings, and click OK at J.
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.
