Database Projects

May 5, 2014 at 8:51 PM
We are currently experiencing a bit of an issue with TFS. We just recently migrated to TFS from VSS.

The main product we support is a third party product. We have access to the database, which we have customized and added to. We also have a slew of other applications and interfaces that are built around our main product.

We have 2 databases one for the main product and an interface database. These are linked servers. In source safe we used linked files to store sql under the application it was written for and a database scripts project which contained all objects specific to each database.

Now in TFS we are wanting to convert our sql to visual studio database projects. We want the code to exist in a central location and in our application folders. We are not using custom schemas.

I want to know if anybody has been in a similar situation and how they handled it. Let me know if you need more information.