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 and synchronize objects (views, stored procedures, etc.)

Open databases (see Schema changes summary use case) and 1click on interested object type, for example Views:

for SQL Server, home tab click views

You can also click on New or Changed counts to see only new or changed objects respectively. In the opened Object list tab 2select required object(s) and 3click merge button:

for SQL Server, object list select view and click merge

It will open merge confirmation dialog with synchronization script. Click 4'Run' to apply changes:

for SQL Server, object list review merge script and run

To review particular object changes, click on the required object name to open the Text diff tab with object text:

for SQL Server, object list click view and open text diff

In the Pro version you can also 5choose to show only new and/or changed lines:

for SQL Server, text diff tab show new and changed view lines