Open menu KS DB Merge Tools logo KS DB Merge Tools for SQLite logo

Schema Changes Summary

In this use case, we connect to two SQLite databases, read object definitions, and get a schema changes summary — the total counts of new and changed tables, views, and other objects. This use case is also the starting point for most others: before comparing or synchronizing objects or data, you first need to connect to the databases and load their definitions.

  1. Click A 'Open database(s)' to start connecting to your databases.

    for SQLite, home tab blank
  2. Select the database files B. If the files are located in the same directory, you can select both of them using the Shift key, otherwise open them one by one. Click C OK.

    for SQLite, home tab open databases
  3. Wait a bit while the tool loads the database definitions. You’ll see a progress indicator D.

    for SQLite, progress indicator while loading
  4. After loading, you’ll see the total, new, and changed object counts for each type (tables, views, etc.).

    for SQLite, home tab schema changes summary