SQL Server Schema Compare

The SQL Server Schema Compare extension

This extension is very helpful when you have multiple copies of the same database, and you would like to determine if they are the same or out of sync with respect to their schema definitions (tables, views, procedures, functions, etc.). Note that this extension does not compare data contained in the tables, only table (and other object) definitions.

To find this extension, click on the Extensions icon in the Activity Bar and type “compare” in the search textbox. You should see the SQL Server Schema Compare extension appear below the search textbox, as shown below: