Deploying a DacPac to Azure SQL with Azure Pipelines and Managed Identities

Christopher Derrig
Nov 5 · 9 min read

We’ve all been there; we need to automate our database changes to each environment in our pipeline. There are a multitude of ways to do it, and what works for you may not work for me and vice-versa, but I generally like to simplify my life as much as possible.

In this post I’ll show you how, after a lot of trial and error, I managed to both automate and secure my database schema changes with Azure Pipelines. My main requirements were two-fold;

  1. I can not have username/password…

Keep the story going. Sign up for an extra free read.

You've completed your member preview for this month, but when you sign up for a free Medium account, you get one more story.
Already have an account? Sign in

Christopher Derrig

Written by

Christopher Derrig is a Full Stack Developer helping to bring enterprises to the Cloud. Specializes in Angular and the Microsoft Stack (C#, SQL Server, Azure)

Microsoft Azure

Any language. Any platform. Our team is focused on making the world more amazing for developers and IT operations communities with the best that Microsoft Azure can provide. If you want to contribute in this journey with us, contact us at medium@microsoft.com

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade