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

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

SQL Compare product page

Latest version: Release notes for SQL Compare 12.4

Worked example - comparing and deploying two databases

Using the command line