Comparing Databases in MS SSMS

This topic explains how to start comparing databases in MS SSMS.

Comparing Schemas

  1. In Object Explorer, right-click a database, point to Data Compare, and then click Set as Source or Set as Target.

  2. Depending on your choice in previous step, drag source or target database from Object Explorer to the dbForge Data Compare for SQL Server window.

  3. Click the green arrow button to open the dbForge Data Compare for SQL Server desktop application to proceed with schema comparison and synchronization.