TFS Build failing on .dbproj files

Question

I have a solution with 2 database projects, each includes a reference to another .dbschema. The project builds manually successfully, but when I try to queue a TFS build using the build server I get these errors:

I know I want the relative paths instead of the "..\\..\\.."  but I'm not sure how to make that happen.  I tried editing the .SLN file but it's not seeming to have any effect.  What am I missing?

---

J. Way

Answer 1

Hi Judy,

Thanks for your post!

You’ll need to have VSTE for Database Professionals  and SQL Server installed on the build agent.

For more information, please refer to http://blogs.msdn.com/b/buckh/archive/2007/09/11/vsts-2005-and-2008-building-database-projects-with-team-build.aspx

Hope it helps!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 2

I have VS 2010 Ultimate already installed, is that ok or do I still need VSTE for DB Professionals?  

There are 5 issues talked about in the link you sent, which did you find relevant to the errors I'm getting ?

---

J. Way

Answer 3

Hi Judy,

Thanks for your feedback!

I think the issue is more relevant with Issue #5: Database Unit Tests cannot find database project files, data generation plans, or the database instance(s) to be used for running tests when run via Team Build.

Please try to follow the method in the link which I supplied in my first reply, and see if it helps.

In TFS 2010, please refer to http://blogs.perficient.com/microsoft/2011/05/team-build-2010-deploying-a-database-with-msbuild-on-team-build-2010/

and http://msdn.microsoft.com/en-us/library/ff805001.aspx

Hope it helps!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 4

The first step under #5 says:

• Create a file named app.TeamBuild.config by copying the existing app.config in your unit test project. Add it to your unit test project in version control.

I don't have any .config files in my overall solution or in the database projects.  I'm not using a unit test project I'm using a web application project with 2 database projects in it.  Is there a different file I should be editing ?

---

J. Way

Answer 5

Hi Judy,

Thanks for your feedback!

Maybe the issue#5 is not your issue. So have you tried other method for issue's which are mentioned in http://blogs.msdn.com/b/buckh/archive/2007/09/11/vsts-2005-and-2008-building-database-projects-with-team-build.aspx?

In addition, has the SQL Server is installed in your build machine?

Hope it helps!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 6

SQL Server is installed on the build machine.  I read through the article and I'm not experiencing any of the errors or symptoms described in it.  I can't get a successful build from the build server and I need to find a way to change the path that it's using for the project .proj file references as in the first post above.

---

J. Way

Answer 7

Hi Judy,

Thanks for your feedback!

Can you find the PortalDatabase.dbporoj file in the path C:\Builds\5JHAKnow\DBProjects Build\Sources\Dev\Test\DBProjects Build\Sources\Dev\Test\DBProjects\..\..\..\..\..\Juway\documents\Visual Studio2010\Projects\JHAKnow\Dev\Test\PortalDatabase ?

Have you check in the database project to version control?

What version of Team Build do you use? Team Build 2008, Team Build 2010 or Team Build 2012?

Have you change the Build Process Template as described in the following link:

http://msdn.microsoft.com/en-us/library/ff805001.aspx

Hope it helps!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 8

I got pulled onto another project, sorry for the delay in getting back to you.  The file  PortalDatabase.dbproj   is not in the path  C:\Builds\5JHAKnow\DBProjects Build\Sources\Dev\Test\DBProjects Build\Sources\Dev\Test\DBProjects\..\..\..\..\..\Juway\documents\Visual Studio2010\Projects\JHAKnow\Dev\Test\PortalDatabase

That path doesn't exist.

In this path:  C:\Builds\5\JHAKnow\DBProjects Build\Sources\Dev\Test\DBProjects\DBProjects    

I have a DBProjects.vbproj file, that's the one for my wrapper solution that contains the 2 db projects.  But nothing in that path with a .dbproj extension.

We are using Team Build 2010 with VS Ultimate 2010

---

J. Way