OpenTube

Next-gen SQL Projects with Microsoft.Build.Sql

Microsoft Visual Studio

10,016 views

With Microsoft.Build.Sql SDK-style SQL projects, your database objects are stored as code for streamlined development and source control. Integrated SQL code analysis and dynamically generated deployment plans through tools like SqlPackage CLI enable reliable and trustworthy updates whether you're managing a single database or an entire fleet. When your SQL database is deployed to Fabric, source control integration is part of the database platform. In this session we’ll learn how to develop and deploy your database alongside your app components with SQL projects from the IDE to CI/CD in SQL Server, Azure SQL, and SQL database in Fabric. Armed with examples for Azure DevOps and GitHub Actions, you’ll be ready to automate steps in your development process and streamline database changes.

You will learn:
How to develop and deploy your database alongside your app components
How to automate database deployment steps across multiple environments
How to improve database code quality with CI checks

Azure free trial: http://aka.ms/devrelFT
Visual Studio: http://visualstudio.com
VS Live on-demand sessions: https://aka.ms/vslivehq25
Missed the fun at MS HQ?! Join one of these upcoming events, we’ll see you there! VSLive events: https://aka.ms/VSS/VSLive
Subscriptions portal: https://my.visualstudio.com

5 Comments

@ericvenneker 1 year ago

This is a very informative talk. Thank you!

@adds-kz3oc 1 year ago

Isn't this still in "preview"? We've been using SDK style SQL projects for years now, but it never truly seems supported as a first-class citizen.

@gafman5569 1 year ago

Do you have a timeline for when this will come out of preview?

@swift-cut 1 year ago

sqlpackage is ok, not great, I mean its great when you want to use what it provides as is... but, handling options and contributors an testing everything when you need more advanced stuff to do, when you have serious project, its unmanageable without putting serious constraints on developers, it was a deal breaker for me, wrapping it in powershell is pointless, I ended up building my own cmdline interface with options I need and using DacFx directly... but this library needs some serious work:P so its nice you are investing time to improve this tooling :)

@CoolTebza-eh7ig 1 year ago (edited)

This database should be specific categories built or used for than just get that set database with all required information about specific projects 🤔, like if the teacher gets information for that the teacher choose what gonna educate but checklist what needed for each term like to list but with schedule list of information how to use it on different api backend use cases, alot can be done which just make AI that will deal with such professional level no third party code based sessions, but straight forward interface environment for database structured data.