Build DACPAC with references

[jmezach]

At the moment it seems that it is not possible to build a dacpac that references objects in other dacpac packages, or I just can't figure out how to do it. Is this something that's planned to be added?

[Coder3333]

@jmezach , did you ever figure this out? If you right click References on the project from Visual Studio and then select "Add Database Reference", it brings up a screen where you can select another dacpac to reference.

[Adam-S-Daniel]

I suggest renaming this issue to correspond to this ticket on Developer Community: “On Roadmap” since 2020: NuGet database references in SSDT database projects. I agree with @Coder3333 that the current name implies a feature that already exists: direct references to DacPac files, akin to the bad old days when one might add a reference to a DLL as opposed to achieving the same through a NuGet dependency.

@dzsquared, might it make sense for your team to reach out to @nkolev for the NuGet team’s thinking/guidance on this? https://github.com/NuGet/Home/issues/545#issuecomment-1245941067

Team Triage:

The work that would be required here needs to be done by a different component, the SQL server Database Tools projects and not NuGet.

Please upvote and follow the following issue in the DacFx repo, microsoft/DacFx#124.

[dzsquared]

Now available in preview with Microsoft.Build.Sql - https://github.com/microsoft/DacFx/blob/main/src/Microsoft.Build.Sql/docs/Functionality.md#package-references