Continuously deploying SQL code using Powershell

on YouTube ↗44m

" summary

Claims a working pipeline for continuously deploying plain-text SQL using the DBOps PowerShell module (built on DbUp), showing export/build/deploy cycles, packaging artifacts like a dacpac zip, and a build system that produces versioned packages. Demos create a schema_versions journal, run scripts in order, wrap deployments in a single transaction option, publish artifacts to a repo, and invoke Jenkins jobs. Cross-platform support and hundreds of Pester tests are asserted and live demos complete successfully.

AI-written summary · about

" chapters (6)

1. 0:00Start
2. 2:43sql deployment scenarios
3. 7:03model-based approach: dacpacs
4. 18:24script-based deployments
5. 20:17dbops powershell module
6. 26:42Deployment package

" related talks

• 48mConnecting the dots of Azure SQL DevOpsMuazma Zahid · SQLBits 2023
• 01h 09mAzure SQL Database Development Inner and Outer LoopsDrew Skwiers-Koballa · Visual Studio Live! Microsoft HQ 2022
• 22mAdvanced Azure DevOps With Containers and Pipeline As CodeChris Adkin · SQLBits 2020
• 48mApplying effective Source Control to your Database SystemKarim Ourtani · SQLBits 2019
• 01h 00mDevOps for Your Relational Database FoundationsBrian A. Randell · NDC London 2021
• 49mUnveiling the magic of CI/CD for SQL Server using GitHub ActionsSANDER STAD, Kevin Chant · SQLBits 2019
• 01h 12mNext-gen SQL Projects with Microsoft.Build.SqlDrew Skwiers-Koballa · Visual Studio Live! @ Microsoft HQ 2025
• 01h 11mFree Continuous Delivery to the PowerShell Gallery with Azure DevOpsRob Sewell · PolarConf 2018