Red Gate forums :: View topic - Recommendation for TFS organization structure for DBAs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Recommendation for TFS organization structure for DBAs

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jasoncleme



Joined: 16 Jan 2013
Posts: 3

PostPosted: Wed Mar 06, 2013 5:14 pm    Post subject: Recommendation for TFS organization structure for DBAs Reply with quote

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?

Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Wed Mar 06, 2013 5:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group