KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
MssqlMerge logo for SQL Server
aka MssqlMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite 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 SQL Server, 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 SQL Server, object list click compare data and choose key

to open Data diff tab with result:

for SQL Server, data diff all records

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

for SQL Server, data diff new or changed records