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 ad hoc query result

Open databases (see Schema changes summary use case) and 1click 'Query result diff' toolbar button:

for SQL Server, click query result diff

In the opened Query result diff tab specify 2mapping type, 3query text and 4click Run.

for SQL Server, query result diff set up options

Then 5specify expected unique key fields and 6click OK:

for SQL Server, query result diff run and choose keys

and get the result:

for SQL Server, query result diff can show new and changed

where you can 7apply additional filter to show only new and/or changed rows:

for SQL Server, query result diff new and changed rows