With SQL Compare, you can compare and deploy the structure of two Microsoft SQL Server databases.

SQL Compare includes a free add-in for SQL Server Management Studio you can use to compare and deploy databases from SSMS. For more information, see Getting started with the add-in.

SQL Compare product page

Latest version: Release notes for SQL Compare 10.7

Deploying the data sources

Using the Deployment Wizard

Using the command line