DCSIMG
Visual Studio Team System – Database Project won’t compile - .NET Geek

.NET Geek

"It is upon the Trunk that a gentleman works" - Confucius

Visual Studio Team System – Database Project won’t compile

We use Database Projects to keep multiple versions of our databases in sync (both schema and data). Lately I’ve encountered several annoying build errors. The cause for all of them seemed to be related to the fact that the validation database had gotten out of sync.

Partial error message (so that SE can pick it up): Error 7 TSD7031: An object with name already exists in the database project…

Solution:

  • Close the database project.
  • If the validation database is still present on the server, delete it. (The name of the database is ProjectName_GUID, where ProjectName is the name of the database project)
  • Delete the ProjectName.dat file.
  • Reopen the database project.
Posted: Nov 24 2008, 07:06 AM by Kim | with 2 comment(s)
תגים:,

Comments

neongreen said:

Thank you, thank you, thank you.....I mean it's like you posted this solution just for me...Kim you truly are a lifesaver ...I mean at the time of writing this comment I am at work and we have had the same problem and could not figure out how to solve this <a href="http://www.notionsolutions.com">VSTS</a> problem...and well we couldn't leave work until it was done...and well now thanks to you it so solved :)

Cheers!

# November 27, 2008 9:52 AM

Stephen Wells said:

Thanks! I wonder when they will fix this bug?

# May 12, 2009 9:13 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 


Enter the numbers above: