Forum Discussion

wilson_smyth's avatar
wilson_smyth
Copper Contributor
Nov 26, 2021

Azure Devops failing to build sql server database project

I have a sql database project in Visual Studio (2019). I am trying to deploy it via azure devops.   The pipeline is failing due to the below error:     ##[error]C:\azagent\A1_work\r1\a_Transcri...
azure devops
  • wilson_smyth's avatar
    wilson_smyth
    Copper Contributor
    Dec 01, 2021

    sebasmoreno14 
    Hi.

    I didnt find an exact fix, but i got round the issue.

    instead of doing the build in the release pipeline i do it in the build pipeline. for some reason it works without issue in there.

    • sebasmoreno14's avatar
      sebasmoreno14
      Copper Contributor
      Dec 01, 2021

      Hi !wilson_smyth Thanks  very much for the reply.

       

      After fight a little bit with all this problem I could resolve it with the next steps (I hope it helps someone):

       

      1. Create a build Pipeline with the next set of tasks, this pipeline is responsible about generate the build of the solution in which you can find the project of type “Database SQL Server Project”,  This build will generate the artifact DACPAC.   

      2. In my release Pipeline I put one task of type  Azure SQL DacpacTask, in this task you have to configure the target database the  .dacpac file (generate in the build - step  1.)   

       

       

       

       

       

       

Resources