Split TFS2010 Collection in two

ByTrent Jones

Split TFS2010 Collection in two

I kept reading online how you could split TFS Collections in Visual Studio Team System 2010 in 2 but really couldn’t find any information on how to do it so i went upon trying this myself.  For instance, you may have a collection with projects A,B,C,D and you want to collections: one with A,B and another with C,D. 

  1. Detach the collection from TFS Admin Tool.
  2. backing up the corresponding collection db via SQL Management Studio.  (there is one db in sql per collection)
  3. Copy and Paste the back-up and Rename it
  4. Restore Database” in Management Studio. Use new name with “TFS_<YOURNAME>”
  5. Use TFS admin tool to identify existing collection to attach
  6. Use TFS Admin tool to attach new collection db.\
  7. Use VS Explorer to drop out projects not necessary in new collection

SharePoint connectivity is a whole other issue/post

Any TFS Gurus out there have more information please let me know and I will update this post.  I kinda thought there would be a command line tool to do this.

About the Author

Trent Jones administrator