Using Azure Pipelines for Azure SQL Deployments | Data Exposed

Many organizations have complex security and deployment requirements. In the second of this two-part series with Arvind Shyamsundar, we show you how to leverage Azure Pipelines features like multi-stage pipelines and AZ CLI support, to securely deploy an Azure SQL Server and Database into a private VNET in Azure.

0:00 Introduction
1:00 Changed-based approach
1:35 State-based approach
3:30 Demo
8:23 Demo Background
12:07 Back to Demo
19:11 Demo: pipeline execution
22:45 Key takeaways
24:50 Getting started

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzurePipelines #AzureSQLDeployments #AzureSQL

[ALLInOne-nnny]

I have an linux sles VM, will that not work for deploying dacpacs? Am using github.

[pankajkrlakhchaura]

Great knowledge sharing. I have a query if you could answer. Why you are creating a separate pipeline for SQL deployment. Can not we have tools to deploy the SQL artifacts with code? I have a big project which has three components to deploy together. Angular for UI, .Net core for API and SQL tables and procedure. when a developer completes the development of a new functionality then he commits Angular code, API code and SQL tables and stored procedures. Now the challenge is to deploy all these three parts together ( in sequence of course ) through Ci/CD. I do not see any way to do this. I have googled it but did not find the solution. For code, CI/CD pipelines is there but it is not in sync with the SQL objects. Do we have any way to do this?

[hydtechietalks]

Could not he show the delta changes... selling too many shells!

[sandeep-bptu]

pls send the link to the yaml pipeline

[seanrhone]

What if you have 100 databases you want to deploy to? How can you dynamicly supply the database list and how does the deployment work?

[MunindherReddy]

Do we have steps to create SQL deployment scripts and incremental sql deployment scripts? like Differential scripts?

[remandlo]

informative content. thanxs for putting together the go-through..

[fudhater]

Is there a way to do this without hand-editing YAML?

[omarvega]

some one can say to me where is the previous video?

[remandlo]

I have a self-hosted agent, with the sqlpackage capability enabled and my pipeline fails on the SQL Azure DacPacDeployment task with the following error:
The current operating system is not capable of running this task. That typically means the task was written for Windows only. For example, written for Windows Desktop PowerShell.

I am not quiet sure where does the task pickup the non windows OS.