Database CI/CD with Docker Containers and Azure DevOps
summary
Demo shows a Visual Studio database project producing a dacpac built into image via Azure DevOps build pipeline, then a Linux Docker image (Ubuntu + SQL Server 2019 + sqlpackage) is built and pushed to Azure Container Registry. tSQLt tests run inside the image and are forced to fail builds by tSQLt severity raised to 20. Release pipeline deploys the image to AKS and runs tests; the end-to-end process completes successfully but large databases make huge images and tSQLt tasks require Windows agents.
AI-written summary · about
chapters (8)
- 0:00Introduction and agenda
- 3:02Demo architecture overview
- 7:38The development story
- 10:33Building the pipeline
- 22:18Deployment and containerization
- 28:27Testing strategy
- 32:55Release management
- 41:10Summary and conclusions
related talks
56mDeploying Docker for Database DevOps Dominance
48mConnecting the dots of Azure SQL DevOps
50mA Deep Dive into DevOps Practices with Azure SQL
01h 09mAzure SQL Database Development Inner and Outer Loops
40mDevOps and Kubernetes in VSTS on Azure and Beyond
45mDev and Test Agility for your Database with Docker
39mDatabase DevOps with Containers
01h 07mDev and Test Agility for your Database with Docker