Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
MssqlMerge logo for SQL Server
aka MssqlMerge
KS DB Merge Tools for MySQL logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for Oracle 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
Other tools

Schema Changes Summary

In this use case, we connect to two SQL Server 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 SQL Server, home tab blank
  2. Specify connection settings at B. If both databases are on the same server, enable C 'Use the same options' to reuse settings for the second database (only DB name needed). Click D 'OK'.

    for SQL Server, home tab open databases
  3. Wait while the tool loads the database definitions. You’ll see a progress indicator E.

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

    for SQL Server, home tab schema changes summary