| Titel: |
End-to-End Database DevOps: Building Automated CI/CD Pipelines for Azure SQL |
| Vortragsart: |
Breakout Session auf Fachkonferenz |
| Datum: |
02.07.2026 14:15 bis 15:15
|
| Dozent(en): |
Torsten Strauß |
| Preis: |
Siehe Veranstaltungs-Website |
| Ort: |
Mannheim |
| Veranstaltung: |
DWX - Developer Week 2026 |
| Veranstalter: |
Ebner Media Group GmbH & Co. KG |
| Inhalt: |
Implementing database DevOps remains one of the most challenging aspects of modern CI/CD workflows.
This session demonstrates how to build a fully automated YAML pipeline in Azure DevOps for continuous integration and deployment of Azure SQL Databases.
The process begins with generating a schema drift report to detect discrepancies between the live database and the intended schema. This report is reviewed and approved before any deployment occurs, ensuring controlled, auditable, and transparent change management.
Once approved, the pipeline enters the build phase, where a .dacpac file is compiled and published to a dedicated artifact feed — providing clear versioning, auditability, and rollback capabilities.
The final phase deploys the validated changes to the target environment while minimizing downtime and ensuring consistency.
To promote scalability and standardization, the pipeline uses two reusable YAML templates stored in a central repository, enabling easy adoption across teams and environments.
By the end of this session, attendees will understand how to design repeatable, low-risk, and fully automated database deployments that integrate seamlessly into existing Azure DevOps workflows. |
| Link zu Details: |
Leider kein aktueller Link vorhanden |