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
- attempt to fix #615 — committed to ErikEJ/MSBuild.Sdk.SqlProj by ErikEJ 2 years ago
- Attempt to fix #615 — committed to ErikEJ/MSBuild.Sdk.SqlProj by ErikEJ 2 years ago
- Attempt to fix #615 (#638) — committed to rr-wfm/MSBuild.Sdk.SqlProj by ErikEJ 2 years ago
- Attempt to fix #615 (#638) — committed to ErikEJ/MSBuild.Sdk.SqlProj by ErikEJ 2 years ago
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-latestimage) and it was ok.When building project on Windows:
When building project on Linux (Azure DevOps agent):
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
.dacpacon Linux changes anything here.How about 2.8.0 ?