Sebastian Wolff
Automated MS SQL Server database deployments with dacpacs and Azure DevOps
#1about 2 minutes
The challenge of managing hundreds of distributed SQL databases
The core problem was automating deployments across nearly 400 highly customized SQL Server databases on different environments and servers.
#2about 3 minutes
Solution design using dacpacs and Azure DevOps pipelines
The solution involves extracting a database schema into a dacpac, managing it as code in a Visual Studio project, and deploying it via Azure DevOps.
#3about 3 minutes
Implementing the deployment pipeline in Azure DevOps
The pipeline uses MSBuild for building artifacts and WinRM for deployment, with libraries and task groups for reusable, configurable steps.
#4about 12 minutes
How dacpac deployments work with SQLPackage.exe
A dacpac deployment uses SQLPackage.exe to compare the dacpac model with the target database, guided by a publish.xml profile, to generate and apply an update script.
#5about 7 minutes
Handling limitations like multi-environment support
The lack of built-in multi-environment support for objects like users and logins is managed using pre- and post-deployment scripts with SQLCMD variables.
#6about 2 minutes
Advanced customization with deployment contributors
You can extend the deployment process by writing custom C# code using additional deployment contributors to modify SQLPackage behavior, such as ignoring specific objects.
#7about 8 minutes
Q&A on cloud services, dacpac use cases, and PowerShell
The Q&A covers choosing cloud providers, scenarios where dacpacs are not recommended, the use of PowerShell scripts, and handling relational constraints during deployments.
Related jobs
Jobs that call for the skills explored in this talk.
Matching moments
03:47 MIN
Applying software engineering practices to data pipelines
Enjoying SQL data pipelines with dbt
Unlock full access
Log in or set up an account to access this feature and more.
03:39 MIN
Automating deployments and leveraging managed services
Cloud-nativeApplications- What’s the buzz about
Unlock full access
Log in or set up an account to access this feature and more.
03:02 MIN
A DBA's journey to running SQL Server on Kubernetes
Adjusting Pod Eviction Timings in Kubernetes
Unlock full access
Log in or set up an account to access this feature and more.
04:09 MIN
Understanding the unique challenges of database DevOps
Database DevOps with Containers
Unlock full access
Log in or set up an account to access this feature and more.
05:00 MIN
Using the Modern Data Stack and DBT for transformations
Modern Data Architectures need Software Engineering
Unlock full access
Log in or set up an account to access this feature and more.
04:04 MIN
Key takeaways for building event-driven systems on Azure
Implementing an Event Sourcing strategy on Azure
Unlock full access
Log in or set up an account to access this feature and more.
04:11 MIN
Applying a Git-like workflow to database schema changes
Branch your database like your code: How schema changes and pull requests go hand in hand
Unlock full access
Log in or set up an account to access this feature and more.
01:55 MIN
Merging data engineering and DevOps for scalability
Software Engineering Social Connection: Yubo’s lean approach to scaling an 80M-user infrastructure
Unlock full access
Log in or set up an account to access this feature and more.
Featured Partners
Related Videos
39:15Database DevOps with Containers
Rob Richardson
26:53Enjoying SQL data pipelines with dbt
Matthias Niehoff
43:26Develop enterprise-ready applications for Microsoft Teams with Azure resources on modern web technologies
Markus Möller
48:05Branch your database like your code: How schema changes and pull requests go hand in hand
Johannes Nicolai & Lilli Seyther-Besecke
56:19Plan CI/CD on the Enterprise level!
Pawel Piwosz
51:13Demystifying DevOps—Pros, cons, dos & don'ts
Thomas Fuchs, Waleed Arshad & Frank Dornberger & Idir Ouhab Meskine:
34:00Implementing continuous delivery in a data processing pipeline
Álvaro Martín Lozano
46:06CD2CF - Continuous Deployment to Cloud Foundry
Dominik Kress
Related Articles
View all articles
From learning to earning
Jobs that call for the skills explored in this talk.
Devoteam
HTML
Microsoft Access
Schmieder GmbH
Schwarz Dienstleistung KG
Intermediate
HTML
YAML
NoSQL
Terraform
Microsoft Dynamics
+1