Public Preview: Database DevOps in SSMS powered by SQL projects

Bring the benefits of schema-as-code to your database development workflow. SQL database projects enable you to source control your database schema, perform reliable deployments to any environment, and integrate code quality checks into your development process, all from within SQL Server Management Studio (SSMS).

A SQL database project is a local representation of SQL objects that comprise the schema for a single database, such as tables, stored procedures, or functions. The development cycle of a SQL database project enables database development to be integrated into a continuous integration and continuous deployment (CI/CD) workflow, a familiar development best practice. With this release, you can use Microsoft.Build.Sql SDK-style projects in SSMS, giving you a consistent experience with Visual Studio Code SQL projects.

Whether you're managing a single database or orchestrating complex deployments across multiple environments, SQL projects in SSMS provide the foundation for modern database DevOps practices.

Learn more.