Recommendation for TFS organization structure for DBAs

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

Recommendation for TFS organization structure for DBAs

Postby jasoncleme » Wed Mar 06, 2013 5:14 pm

Sorry for the misuse of terms. I'm new to source control.
Does anyone have recommendations for TFS organization structure for DBAs only?

Should our source folder pathing be?
$\\DBA\\username?

$\\DBA\\Servername\\Database_name?

$\\DBA\\Servername\\Database_name\\Project?

We thought we try the TFS because we have MSDN subscriptions and have a enough licenses to support the DBA team.

We have 500+ SQL servers and 50-100 DBs on each server. We were thinking many of the DBs are third party and we wouldn't need to source control those DBs. But any DBs we do customization or are built and maintenance by us we would want it in TFS server correct?

Image
jasoncleme
 
Posts: 3
Joined: Wed Jan 16, 2013 4:00 pm

Postby David Atkinson » Wed Mar 06, 2013 5:54 pm

Yes, I wouldn't go so far as to source control third party DBs, as the vendors should (hopefully) be doing this themselves!

But any custom changes you've made to your databases count as development and should be source controlled.

In terms of the folder hierarchy in TFS that's very much a question of your internal company structures and personal preference. As it's a generic "how to structure source control", it might be worth posting the question on StackOverflow in order to get more exposure?

Putting the server name as a folder might be problematic if you later rename the server. Maybe it should be more related to the product that the database is part of?

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest