WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
WeAreDevelopers LIVE • Nov 10, 2021

Automated MS SQL Server database deployments with dacpacs and Azure DevOps

Sebastian Wolff

Stop manually tracking sequential release scripts for your SQL databases. By integrating DACPACs with Azure DevOps, you can treat schemas as code and fully automate state-based deployments.

Pause
Mute Enter Fullscreen
#1 about 7 min

Resolving deployment issues across hundreds of databases

Automating SQL Server database changes replaces manual scripting across highly distributed custom environments.

#2 about 3 min

Architectural overview of automated database deployments

Generating code from standard SQL databases creates baseline artifacts for deployment via source control.

#3 about 3 min

Utilizing Azure DevOps for database pipeline automation

Managing variables and standardizing steps through pipeline libraries and task groups scales continuous delivery seamlessly.

#4 about 8 min

Core components and internal structure of dacpacs

Controlling parameters through publish profiles enables granular management of structural SQL object changes and data loss prevention.

#5 about 5 min

Validating and publishing with SQL package executables

Generating standalone deployment scripts before execution provides safer validation of target database updates against existing states.

#6 about 9 min

Handling multi-environment variances and missing features

Utilizing pre-deployment and post-deployment scripts injects manual security contexts and specific table operations unsupported natively.

#7 about 3 min

Selecting cloud providers and identifying dacpac alternatives

Recognizing constraints within smaller teams dictates whether data-tier automation brings tangible value over simpler schema updates.

#8 about 5 min

Managing procedural drops and performance in deployment

Integrating automated PowerShell pipelines and systematically sequencing constraint truncation avoids relational referential issues.

Matching moments

4:15 min

Automating feature environment provisioning with Azure DevOps pipelines

Thomas Hartenstein · LIVE

1:56 min

Implementing state-driven deployment architecture using automated pipeline integration tools

Lian Li · WWC 2023

3:51 min

Balancing automated deployments with human infrastructure oversight

Hazal Mestci +1 · Coffee With Developers

5:50 min

Demonstrating automated deployment sequences via Git repositories

Thomas Schütz · LIVE

1:37 min

Building automated continuous deployment pipelines and final architectural insights

Simone Desantis Simone Desantis · WWC Europe 2026

4:59 min

Bringing DevOps practices to data transformation with DBT

Matthias Niehoff Matthias Niehoff · WWC 2024

More from WeAreDevelopers LIVE

Aliens in Quarantine, Python Deprecates Loops, and AI Buys Old Books - Zbyszek Tenerowicz thumbnail
5:43
5 days ago

Aliens in Quarantine, Python Deprecates Loops, and AI Buys Old Books - Zbyszek Tenerowicz

Chris Heilmann, Daniel Cranney

WeAreDevelopers LIVE - Node and Package Security thumbnail
1:08:30
5 days ago

WeAreDevelopers LIVE - Node and Package Security

Chris Heilmann, Daniel Cranney, Zbyszek Tenerowicz

WeAreDevelopers LIVE - Streaming HTML thumbnail
1:10:26
12 days ago

WeAreDevelopers LIVE - Streaming HTML

Chris Heilmann, Daniel Cranney, Jad Joubran

WeAreDevelopers LIVE - CODE100 at WeAreDevelopers Europe thumbnail
1:02:34
19 days ago

WeAreDevelopers LIVE - CODE100 at WeAreDevelopers Europe

Chris Heilmann, Daniel Cranney, Justin Halsall, Werner Jeschko, Nicole Jeschko, Mirco Tomić

WeAreDevelopers LIVE - Web Performance in an AI World thumbnail
1:07:59
26 days ago

WeAreDevelopers LIVE - Web Performance in an AI World

Chris Heilmann, Daniel Cranney

FIFA Hack, Midjourney Does Ultrasounds, and Trampoline Traffic Lights - Nicole Jeschko and Werner Jeschko thumbnail
5:55
about 2 months ago

FIFA Hack, Midjourney Does Ultrasounds, and Trampoline Traffic Lights - Nicole Jeschko and Werner Jeschko

Chris Heilmann, Daniel Cranney

Upcoming sessions on this topic

Open session

World Congress 2026 North America

Ship 10x Faster: AI-Powered Development with Claude Code and MCP Tools

Viktoria Semaan

Principal Technical Evangelist at Databricks

Viktoria Semaan
Open session

World Congress 2026 North America

Boring Failover: Predictable Region Recovery Across 5,000 Microservices

Garvit Kataria, Sahil Sabharwal

Garvit Kataria
Sahil Sabharwal
Open session

World Congress 2026 North America

Beyond SQL Generation: How to Teach Agents What Your Database Actually Means

Kris Jenkins

Lead Developer Advocate at Snowflake

Kris Jenkins
Open session

World Congress 2026 North America

AI-Powered Incident Triage: How We Built GenAI Agents with MCPs to Automate On-Call Workflows

Prakshal Doshi

Site Reliability Engineer

Prakshal Doshi
Open session

World Congress 2026 North America

Chat with Your Data: From Natural Language to SQL

Alper Ebicoglu

Co-founder of Volosoft

Alper Ebicoglu
Open session

World Congress 2026 North America

Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases

Wei Hu

Senior Vice President of Research and Development

Wei Hu

Related videos

Database DevOps with Containers thumbnail
39:15
LIVE • about 5 years ago

Database DevOps with Containers

Rob Richardson

Developer Tools for Microsoft Azure thumbnail
25:41
WWC 2022 • about 4 years ago

Developer Tools for Microsoft Azure

Radu Vunvulea

Enabling automated 1-click customer deployments with built-in quality and security thumbnail
44:40
LIVE • over 5 years ago

Enabling automated 1-click customer deployments with built-in quality and security

Christoph Ruggenthaler

Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies thumbnail
43:26
WWC 2021 • about 5 years ago

Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies

Markus Möller

Plan CI/CD on the Enterprise level! thumbnail
56:19
LIVE • over 3 years ago

Plan CI/CD on the Enterprise level!

Pawel Piwosz

Securing Your Web Application Pipeline From Intruders thumbnail
44:30
LIVE • almost 6 years ago

Securing Your Web Application Pipeline From Intruders

Milecia Mcgregor

Related articles

From learning to earning

Jobs that call for the skills explored in this talk.