KS DB Merge Tools for SQLite is a diff and merge GUI tool for SQLite database files. This tool can be used to compare and sync both schema and data changes.

The application has a tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks. The starting point is the Home tab - it is used to open databases and show summary about database schema changes: table definitions, views, indexes and triggers. From here, users can drill-down details hidden by these summary numbers - compare lists of objects, definition of particular object or even line of code. Table definitions can be analyzed for changes in particular attributes of column or constraint. Necessary changes can be merged to the other side database using multistep table replacement approach recommended by SQLite authors because of limited ALTER TABLE support.

By opening a list of table definitions or views, data can be compared for a given table or view. Tables are compared by primary key, and for views the user can define a unique comparison key. Using the Batch data diff tool, the data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Large text column value changes can be analyzed separately. Query result diff tool provides the way to compare any arbitrary query result. Query result diff and Custom data diff tools can be used to set up column mapping, configure key columns and ignore some columns if necessary.

Many tabs provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.

Application has a command line tool, designed to automate generation of diff reports and synchronization scripts and can run on Windows and Linux.

KS DB Merge Tools for SQLite is a Freemium application - basic features are exposed in the Free version which is available for commercial use.

KS DB Merge Tools for SQLite

What is KS DB Merge Tools for SQLite?

Categories & Use Cases

Media