0

so we are trying to build an MS SQL database pipeline. the issue that I'm running into is due to dacpac not found. They are in our repo error message

now I did notice that the build is looking at an enterprise pathway. my local build and my push to the repo was from a professional VS version. How can this be resolved? Every DB reference is having the same issue in my solution. my sln files are being recognized just not my Database references.

Tdubs
  • 29
  • 7
  • What does your azure-pipelines.yml look like? Also in the error message the path looks like its pointing to a Debug build? Are you not maybe doing a Release build? – Chad Lamb Jan 15 '21 at 05:43

1 Answers1

0

According to your error message, the reference to the master.dacpac is incorrect. Please open and check your .sqlproj file. You will find the reference to the Master database like this:

<ArtifactReference Include="$(DacPacRootPath)\Extensions\Microsoft\SQLDB\Extensions\SqlServer\130\SqlSchemas\master.dacpac">
  <HintPath>$(DacPacRootPath)\Extensions\Microsoft\SQLDB\Extensions\SqlServer\130\SqlSchemas\master.dacpac</HintPath>

If your Include=" is a hard coded path, you can try to copy the contents of the HintPath element to the Include attribute. Please refer to this ticket for more details.

Walter
  • 2,640
  • 1
  • 5
  • 11
  • I did follow your steps and I'm still getting the same error message. I even recreated my pipeline and still the issues. $(DacPacRootPath)\bin\Debug\master.dacpac True master – Tdubs Jan 15 '21 at 20:01
  • @Tdubs Can you share the configuration of your pipeline? – Walter Jan 18 '21 at 09:26