CODEWITHSUNDEEP
msbuildtfs-2015dacpacdbproj
Dennis Belevantsev
Dennis Belevantsev

Reputation: 3

DBProject TFS 2015 Build ignores external references

We have a TFS 2015 build server running the new Agent in Agent Pool.

Also we have a solution with three MS SQL database projects. One of these projects has references to another two.

When I build this solution in Visual Studio 2015 on my PC, the resulting model.xml includes all views with references through [$(DBName)] variables.

However, when I run the build on TFS, all objects with external references disappear from model, thus they cannot be found in .dacpac file and as result, we cannot do a deployment.

Could someone give a hint how to solve this issue?

Upvotes: 0

Views: 82

Answers (1)

Cece Dong - MSFT
Cece Dong - MSFT

Reputation: 31023

  1. Log on your build agent machine, and check the output of the TFS build to see whether the structure is the same as local build. Also, try to use MSBuild command line to build the solution manually on your build agent machine to see what result will you get.

  2. It seems you reference output assemblies from one project. Instead of referencing output assemblies, it's suggested to make a project reference or create a NuGet package.

Upvotes: 0

Related Questions