KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for SQLite logo for SQLite
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license

Compare and synchronize views, indexes and triggers

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

for SQLite, 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 SQLite, object list select view and click merge

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

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