setting up with TFS 2010 for the first time ... a noob

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

setting up with TFS 2010 for the first time ... a noob

Postby randyvolters » Wed Nov 27, 2013 12:54 pm

Having read the tutorial, I just want to be clear in my understanding.
We're doing a data warehouse development project and want to use SQL Source Control.

In TFS we've set up folders for each 'sprint', with folders having the name format of iterationn where the last n is a number; iteration1, iteration2, etc.

Our data warehouse consists of multiple databases for various layers of the architecture.

In our first attempt at using SQL Source Control, we linked all the databases to the iteration1 TFS folder. The outcome was that everything from all the databases appeared to be merged for any of the databases when they were selected.

I'm guessing what we should do is build a folder in TFS under the iteration1 folder for each database and then link each database to its namesake in the TFS system?

Would that be correct?

Thanks in advance for the assist.
randyvolters
Randy Volters
Data Acquisition Architect
Seibels Insurance and Technology Services
randyvolters
 
Posts: 2
Joined: Fri Nov 08, 2013 1:24 pm
Location: Columbia, SC

Postby james.billings » Mon Dec 02, 2013 1:37 pm

Hi Randy,

Yes, that's right. In short, the folder you link to should contain *only* files related to that specific database. If you link to a folder higher up the tree, we will parse all subfolders and you'll either see objects you weren't expecting (as in your case), or alternatively the tool may throw 'duplicate object definition' errors.

Hope that helps!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest