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 · World Congress 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 · World Congress 2026 Europe

4:59 min

Bringing DevOps practices to data transformation with DBT

Matthias Niehoff

Matthias Niehoff · World Congress 2024

More from WeAreDevelopers LIVE

WeAreDevelopers LIVE - Project Chopin: Make Your Team and Agents Play Along thumbnail

WeAreDevelopers LIVE - Project Chopin: Make Your Team and Agents Play Along

Chris Heilmann, Daniel Cranney, Krzysztof Cieślak

Fake or News - AI Toothbrushes, Carrier Pigeon Tech & Life on Mars - Krzysztof Cieślak thumbnail

Fake or News - AI Toothbrushes, Carrier Pigeon Tech & Life on Mars - Krzysztof Cieślak

Chris Heilmann, Daniel Cranney

Fake or News - AI Music Detectors, Translating Ancient Languages & Tiny Heads in Teslas - Eddie Jaoude thumbnail

Fake or News - AI Music Detectors, Translating Ancient Languages & Tiny Heads in Teslas - Eddie Jaoude

Chris Heilmann, Daniel Cranney

Fake or News: AI Agents Hire Each Other, Spider-Man Ads in Cars & RAM Thieves - Marc Plogas thumbnail

Fake or News: AI Agents Hire Each Other, Spider-Man Ads in Cars & RAM Thieves - Marc Plogas

Chris Heilmann, Daniel Cranney, Marc Plogas

WeAreDevelopers - Of Agents and Robots thumbnail

WeAreDevelopers - Of Agents and Robots

Chris Heilmann, Daniel Cranney, Marc Plogas

WeAreDevelopers LIVE - How DevRel Makes Tech More Human thumbnail

WeAreDevelopers LIVE - How DevRel Makes Tech More Human

Chris Heilmann, Daniel Cranney

Upcoming sessions on this topic

World Congress 2026 North America

September 25, 2026 · 13:30–14:00

Stage 4

From Model Selection to Smart Routing: How to Use the Right LLM for Every Task

Viktoria Semaan

Principal Technical Evangelist at Databricks

Viktoria Semaan

World Congress 2026 North America

September 24, 2026 · 13:30–15:30

Stage 12

GitHub Actions

Austen Stone

Senior Field Actions Specialist, GitHub

Austen Stone

World Congress 2026 North America

September 24, 2026 · 17:30–18:00

Stage 4

Boring Failover: Predictable Region Recovery Across 5,000 Microservices

Garvit Kataria, Sahil Sabharwal

Garvit Kataria

Sahil Sabharwal

World Congress 2026 North America

September 23, 2026 · 13:15–15:15

Stage 8

The AI-Ready Developer Environment — Local Setup, Reproducibility, and Docker

Michael Irwin

Developer Success, Docker

Michael Irwin

World Congress 2026 North America

September 25, 2026 · 14:10–14:40

Stage 3

Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.

Fabiano Amorim

Chief Technology Advisor at PowerTuning

Fabiano Amorim

World Congress 2026 North America

September 25, 2026 · 14:50–15:20

Tech Leaders Stage

Keeping Code Quality at AI Speed

Daksh Gupta, Arthur Hicken, Jack Danger

Daksh Gupta

Arthur Hicken

Jack Danger

Related videos

Database DevOps with Containers thumbnail

LIVE • over 5 years ago

Database DevOps with Containers

Rob Richardson

Developer Tools for Microsoft Azure thumbnail

World Congress 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

LIVE • almost 6 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

World Congress 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

LIVE • over 3 years ago

Plan CI/CD on the Enterprise level!

Pawel Piwosz

Securing Your Web Application Pipeline From Intruders thumbnail

LIVE • almost 6 years ago

Securing Your Web Application Pipeline From Intruders

Milecia Mcgregor

Related articles

AJ

Austin Joy

What Are The Top Skills Required For Azure Developers?

Developing a business application in the cloud is upstream swimming. You need to have an entirely distinct set of knowledge, skills, and abilities to grab the competitive advantages of developing a...

over 4 years ago

What Are The Top Skills Required For Azure Developers?

AB

Andre Braun, GitLab

Now is the time for industrialized software development

Now is the time for industrialized software development Recently, I received a letter from my car’s manufacturer alerting me to a recall. They had discovered a defective part and wanted to replace ...

about 1 year ago

A person developint HTML on a laptop with the sun shining on it.

BB

Benedikt Bischof

Making Data Warehouses Fast: A Developer’s Story

Welcome to this issue of the WeAreDevelopers Live Talk series. This article recaps an interesting talk by Adnan Rahic who teaches the audience how to make data warehouses.About the Speaker: Adnan i...

about 4 years ago

Making Data Warehouses Fast: A Developer’s Story

CH

Chris Heilmann

Dev Digest 132 - Binging WADFlix?

Hello there, watch all the talks of the WeAreDeveloper World Congress, learn prompt engineering and how to sensibly add AI to your apps.Phase 2 of the WeAreDevelopers Cinematic UniverseToday we are...

about 2 years ago

Dev Digest 132 - Binging WADFlix?

From learning to earning

Jobs that call for the skills explored in this talk.

Azure Solutions Architect Expert, Azure Data Engineer Associate

Houston, TX, United States

Expert $99k–232k DevOps Docker Snowflake

Microsoft D365 CRM or Copilot/AI Functional Lead, Senior Associate

Boston, MA, United States

Expert $77k–202k Power BI Test Case Data Migration

Payer Dev, Git & ML-Ops Engineer

Melville, NY, United States

Expert $77k–202k Git YAML Scripting

about 2 months ago

Forward Deployed Software Engineering - Senior Manager

San Francisco, CA, United States

Expert $124k–335k Code Review Api Management Software Systems

Principal Systems Engineer, Database Infrastructure

Expert Remote Ruby MySQL Golang

Data Engineer - Manager

Experienced Github Fastapi Pytorch