MSSQL Extension for VS Code: Introducing Schema Compare (Preview)

Overview

Introducing Schema Compare, a powerful new feature in the MSSQL Extension for VS Code. Schema Compare transforms the task of comparing schemas into a seamless experience, providing intuitive visualization to highlight additions, removals, and modifications between schemas.

Features

• Compare schemas between two DACPAC files, databases, or SQL projects.
• View results as a set of actions to make the target match the source.
• Set comparison options to control the scope of the comparison.
• Apply changes directly to the target or generate a script for later application.

Compare Schemas

To compare schemas:

1. Right-click a database in Object Explorer and select Schema Compare.
2. Modify the Source and Target databases as needed.
3. Click the Options button for customized settings.
4. Select Compare to view the comparison results.

Apply Changes

1. Apply selected changes to the target by clicking the apply button.

What's Next for Schema Compare?

Stay tuned for future updates and enhancements to the Schema Compare feature in the MSSQL Extension for VS Code.