Moving TFS 2010 Project Collection to new server

Question

Hello,

What is involved in moving a Team Project Collection from one instance of TFS 2010 to another instance? We have a Basic installation using SQL Express. We'd like to re-image the server to be Win 2008 R2 with SQL 2008 R2 Enterprise and a clean install of TFS 2010. I thought that I could just detach & backup the Project Collection, then restore & re-attach after imaging the machine. But after doing a little research, it looks like it's going to be much more involved. Here are two articles that I found:

http://msdn.microsoft.com/en-us/library/ms404869(v=VS.100).aspx

http://msdn.microsoft.com/en-us/library/dd936138.aspx

The first sounds absolutely horrendous ... the second sounds more in line with what I had thought the process would be. 

Can anyone offer some guidance with this? 

Answer 1

If you have TFS basic, you dont have reporting services or sharepoint portals, unless you added it later.

You could go for Move a team project collection

 

Answer 2

Hello jabell,

Sorry for the late reply. I did a little digging these days, and I got some knowledge about moving project collections. Things that will be involved in the collection moving vary depend on the settings of the collection you want to move.

1). Reports

If the collection you are moving uses a report server, you should first save the reports used by the collection. For more details information about Exporting and Saving Reports, please see the following article.

http://msdn.microsoft.com/en-us/library/ms157214.aspx

2). Lab Management Resources.

If you are moving the collection to a different domain or intend to use a different System Center Virtual Machine Manager, you must delete the resources that are used by Lab Management from the collection database. For more information, please see:

http://msdn.microsoft.com/en-us/library/ee712732.aspx

3). The Data Warehouse and Analysis Services.

If the deployment from which you are moving the collection uses a report server, you must rebuild the warehouse for Team Foundation and the database for Analysis Services.

4). Site Collection Database

To move a team project collection that uses a SharePoint Web application, you must move the site collection that supports the team project collection to the Web application that will support the collection in the deployment to which you are going to move it.

5). SQL Server

If you are moving the collection database to a server or instance that isn’t host one or more databases for Team Foundation Server, you must prepare SQL Server to host Team Foundation Server database by using the TFSConfig PreSQL command-line utility.

If you have any further concerns, please feel free to let me know.

Thanks,

Vicky Song

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help

Answer 3

See the TFS Admin Guide for 2010, under:

• Administering Team Foundation
  • Managing the Server Configuration
    • Organizing Your Server with Team Project Collections
      • Move a Team Project Collection

 

Answer 4

Check below guide to move TFS DB, Report Server & Sharepoint from one server to another,

http://www.vmwareandme.com/2013/10/guide-how-to-migrate-tfs-project.html

Thanks

---

www.mytricks.in