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 · 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 - Is CSS Catching Up to Flash? thumbnail
1:03:33
9 days ago

WeAreDevelopers LIVE - Is CSS Catching Up to Flash?

Chris Heilmann, Daniel Cranney, Bramus Van Damme

WeAreDevelopers LIVE - Project Chopin: Make Your Team and Agents Play Along thumbnail
1:21:17
17 days ago

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 Cieślak thumbnail
4:23
18 days ago

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

Chris Heilmann, Daniel Cranney

WeAreDevelopers LIVE - Open Source Agent Toolkits thumbnail
1:00:38
23 days ago

WeAreDevelopers LIVE - Open Source Agent Toolkits

Chris Heilmann, Daniel Cranney, Eddie Jaoude

Fake or News - AI Music Detectors, Translating Ancient Languages & Tiny Heads in Teslas - Eddie Jaoude thumbnail
6:16
25 days ago

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
5:46
30 days ago

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

Chris Heilmann, Daniel Cranney, Marc Plogas

Related videos

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

Database DevOps with Containers

Rob Richardson

Developer Tools for Microsoft Azure thumbnail
25:41
World Congress 2022 • over 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 • 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
43:26
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
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.