Schema compare

This article provides an overview of the Schema Compare feature for the MSSQL extension in

Visual Studio Code. Schema Compare compares two database definitions, and applies the

differences from the source to the target, including active database connections,

files,

and SQL projects.

Schema Compare simplifies the process of comparing databases, and gives you full control when

synchronizing them, even across different database versions. You can selectively filter specific

differences, and categories of differences, before applying any changes.

Schema Compare provides the following features:

Compare schemas between two

files, databases, or SQL projects.

View results as a set of actions to match a target against the source.

Selectively exclude actions listed in results.

Set options that control the scope of the comparison.

Apply changes directly to the target, or generate a script to apply changes at a later time.

Save the comparison.

To use the Schema Compare features, install the MSSQL extension for Visual Studio Code:

