SQL Server Schema Compare
Explore how to use the SQL Server Schema Compare extension in Azure Data Studio to detect differences between database schemas, configure source and target databases, review changes, and apply or script these changes for synchronization. Understand the extension's workflow, including installation, activation, and saving configurations for future use.
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:
If you would like to find out more about this extension before installing it, you can ...