Introducing the SDK-style SQL projects in Visual Studio | Data Exposed

Get to know SQL projects in their latest version with the Microsoft.Build.Sql project SDK. With SQL projects you can store your database definition in source control in addition to automating deployments of database object changes through CI/CD environments like GitHub Actions and Azure DevOps pipelines. SDK-style SQL projects are now in preview in Visual Studio and VS Code, adding package references and other improvements to the original SQL projects.
00:00: Introduction
04:25: Demo
09:45: Database references
12:53: Demo
14:52: Getting started
✔️Resources:
Learn more about SQL database projects at aka.ms/sqlproj...
Get the Visual Studio preview with SDK-style SQL projects through aka.ms/ssdt-sd...
📌 Let's connect:
Twitter - Anna Hoffman, / analyticanna
Twitter - AzureSQL, aka.ms/azuresqltw
🔴 Watch even more Data Exposed episodes: aka.ms/dataexp...
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazure...
Microsoft SQL Server: aka.ms/mssqlse...
Microsoft Developer: aka.ms/microso...
#AzureSQL #SQL #LearnSQL

[@gandharjayantaundhe4023]

Great stuff! Thanks!

[@JohnMarsing]

👍 - SQL CMD variable - Database references dacpac - SDK-style SQL project references - Nuget packages

[@nageshhr]

Any thoughts on improving SSIS package development, handling such as simple, change in metadata???

[@UgrevsBoots]

Did you fix recursive objects? I had to abandon the old projects because they couldn't handle database 1 and 2 having references to each other.