MSBuild.Sdk.SqlProj: Version 2.8.1 - master.dacpac reference is not found

Version: 2.8.1 Deployment on Docker image mcr.microsoft.com/mssql/server:2019-latest Sqlpackage version tested with 150.* and the latest 162.3.566.1

sqlpackage returns error:

Initializing deployment (Start) 2024-08-30 12:41:29 *** No file was supplied for reference master.dacpac; deployment might fail. When package was created, the original referenced file was located C:\Users\username\.nuget\packages\microsoft.sqlserver.dacpacs.master\150.1.1/tools/master.dacpac. 2024-08-30 12:41:29 Initializing deployment (Failed)

Notes:

  • master.dacpac is in the same directory as dacpac of database I want to deploy;
  • master is referenced:
<Project Sdk="MSBuild.Sdk.SqlProj/2.8.1">
     ...
    <ItemGroup>
        <PackageReference Include="Microsoft.SqlServer.Dacpacs.Master" DacpacName="master" DatabaseVariableLiteralValue="master" Version="150.1.1" />
    </ItemGroup>
</Project>
  • issue gone once <Project Sdk="MSBuild.Sdk.SqlProj/2.8.1"> was changed to <Project Sdk="MSBuild.Sdk.SqlProj/2.7.2">

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Comments: 39 (10 by maintainers)

Commits related to this issue

Most upvoted comments

Version 2.9.1 is up on NuGet.org now which includes a fix for this.

@rapolas-oag We’ve just published a preview version (2.10.0-beta.6.g87ee574993) up on NuGet.org that normalizes the paths to be all forward slashes. Could you try the test you’ve described in https://github.com/rr-wfm/MSBuild.Sdk.SqlProj/issues/615#issuecomment-2399030319 again with this version to see if that makes a difference?

Took same dackpac which was build on Linux agent and tried to deploy on Docker SQL Server instance (Ubuntu based mcr.microsoft.com/mssql/server:2019-latest image) and it was ok.

When building project on Windows:

  • fails to deploy on Docker Linux;
  • succeed deploy on Windows server;

When building project on Linux (Azure DevOps agent):

  • succeeds deploy on Docker Linux;
  • succeeds deploy on Windows server;

Could be, although this hasn’t really changed between 2.7.2 and 2.8.0 either.

@rapolas-oag Would be interested to know if building the .dacpac on Linux changes anything here.

How about 2.8.0 ?