From manual deployments to automated pipelines

Are you still deploying database changes manually? Copying scripts between environments? Worrying about whether the production deployment will match what worked in dev? It's time to modernise!

This session takes you on a journey from manual, error-prone database deployments to fully automated CI/CD pipelines. We'll start with the fundamentals: bringing your database schema into source control using SQL Database Projects. From there, we'll look at how to build and deploy from a database project.

We will then create a build pipeline that validate changes, and a release pipeline that deploys across environments. Through live demonstrations using SQL Database Projects and Azure DevOps, you'll see exactly how to set up each component.

You'll leave with a clear roadmap and practical techniques to begin database DevOps in your organisation, reducing deployment stress and increasing reliability.

Establish source control for database schemas using SQL Database Projects Build automated CI/CD pipelines that validate and deploy database changes reliably Implement multi-environment deployment strategies with safety gates and rollback capabilities