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

Compare view data

Open databases (see Schema changes summary use case) and 1click on Views:

for SQLite, home tab click 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 2click 'Compare data' for the required view, 3specify key fields combination and 4 click 'OK':

for SQLite, object list click compare data and choose key

to open Data diff tab with result:

for SQLite, data diff all records

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

for SQLite, data diff new or changed records