SQL Server Schema Compare

This lesson will provide you with an overview of the SQL Server Schema Compare extension.

We'll cover the following

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:

Get hands-on with 1200+ tech skills courses.