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 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
AccdbMerge 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 Cross-DBMS, 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 Cross-DBMS, object list click compare data and choose key

to open Data diff tab with result:

for Cross-DBMS, data diff all rows

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

for Cross-DBMS, data diff new or changed rows