KS DB Merge Tools
 
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
and MariaDB
for SQLite
 

Compare view data

1Click 'Open database(s)' toolbar button:

In the opened dialog 2specify database connectivity options and 3click 'OK':

4wait a bit for a progress:

5Click on total or changed count for Views

to open Object list tab with views. Note that rows highlight here is related only to view SQL definition changes and not related to data changes. Then 6click 'Compare data' for the required query:

Then 7specify key fields combination and 8 click 'OK':

to open Data diff tab with result:

Here you can 9apply filter to show only changed and/or new records: