CODEWITHSUNDEEP
azureazure-devops
user8690703
user8690703

Reputation: 37

How to build and deploy dacpac in azure devops

I am new to Azure devops. Here I have a requirement to do dacpac file build and deployment in Azure devops.can anyone help me to share me the step to step procedure. I am using visual studio 2017. Thanks

Upvotes: 1

Views: 10834

Answers (1)

LoLance
LoLance

Reputation: 28106

How to build and deploy dacpac in azure devops

You can use build pipeline to build that and then deploy it using release pipeline.

  1. If you developed the sql server project by VS, you can publish it to Azure Devops Repos following this document.

  2. Then create a build pipeline following this, you can use classic UI editor without YAML to configure your pipeline.

    1. Select the Azure Devops Git as source. And choose the sql server project published from VS.

    2. Choose the agent you want to use in Agent Job, Hosted agent or Private agent.

    3. Click the + in Agent Job to add a task. You can choose the Visual Studio build task, this task will call msbuild.exe to build your sql server project.

  3. To deploy the output of sql server project, there're many choices. One is to use Windows Machine File Copy task to deploy the files in current agent to destination folder in remote machine. You can use this task in Release or even Build Pipeline to do that.

Hope it helps and if I misunderstand anything, feel free to contact me.

Upvotes: 8

Related Questions