Now available in both Visual Studio and Visual Studio Code, Microsoft.Build.Sql projects are a database development and deployment toolkit for SQL Server, the Azure SQL family, and Fabric Data Warehouse. This update adds SQL projects based on the Microsoft.Build.Sql SDK, which brings cross-platform support and improved package references to SQL Server Data Tools (SSDT) projects. With less verbose project files and database reference to NuGet packages, your teams can more efficiently collaborate on large databases in a single project or compile multiple sets of objects from several projects.
You can automate database deployments from a Microsoft.Build.Sql project in Windows and Linux environments where the Microsoft.SqlPackage dotnet tool publishes the build artifact (.dacpac) from the SQL project. The Microsoft.Build.Sql project SDK is open source and developed on GitHub.
Learn more.