Azure DevOps Pipelines deploying database updates from Database Project

Question

I am completely new to Azure DevOPs and CI in general and am trying to set up a simple proof of concept demo automated a build and release of a simple MVC application that has a SQL Server Database Project.

I am able to automate the build, but am struggling to understand how to access the DACPAC file from the Database Project to deploy the database from.

Currently I have a Visual Studio Build task that builds the solution which is then output to my drop directory, but I want to seperately build my database project and have the DACPAC file output into my final artifacts directory.

When my build task runs the following is output in the YAML:

SqlPrepareForRun:
Database -> d:\a\8\s\AzureDevOpsDemo1\Database\bin\Release\Database.dacpac

But its not accessible in the resulting build artifacts

What is the best way to achieve this?

Greg · Accepted Answer · 2019-09-17 12:08:31Z

2

You have to do a CopyFile task that will copy the DACPAC file to the staging directory.

- task: CopyFiles@2
  displayName: 'Copy DACPAC files'
  inputs:
    SourceFolder: '$(System.DefaultWorkingDirectory)'
    Contents: 'Database/bin/$(BuildConfiguration)/*'
    TargetFolder: '$(Build.ArtifactStagingDirectory)'

- task: PublishBuildArtifacts@1
  displayName: 'Publish Artifact: drop'
  inputs:
    PathtoPublish: '$(build.artifactstagingdirectory)'
    ArtifactName: drop

answered Sep 17, 2019 at 12:08

Greg

4,1155 gold badges35 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Azure DevOps Pipelines deploying database updates from Database Project

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related