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

Compare query data

Open databases (see Project changes summary use case) and 1click on Queries:

for MS Access, home tab click views

to open Object list tab with views. Note that rows highlight here is related only to query SQL definition changes and not related to data changes. Then 2click 'Compare data' for the required query, 3specify key fields combination and 4 click 'OK':

for MS Access, object list click compare data and choose key

to open Data diff tab with result:

for MS Access, data diff all rows

Here you can 5apply filter to show only changed and/or new rows:

for MS Access, data diff new or changed rows