DBProject TFS 2015 Build ignores external references

0
votes

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?

1
msbuildtfs-2015dacpacdbproj
How do you reference one project to another two? How's your build definition like? – Cece Dong - MSFT

1 Answers

0
votes

  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.