KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for MySQL logo for MySQL
and MariaDB
KS DB Merge Tools for Oracle logo
MssqlMerge 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 MySQL, 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 MySQL, object list select view and click merge

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

for MySQL, 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 MySQL, 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 MySQL, text diff tab show new and changed view lines