Upgrade: TFS 2005 to TFS 2010

This document details step by step procedure to upgrade a TFS 2005 single server instance to a TFS 2010 (RC) single server instance with Reports and SharePoint.

Environment details:

TFS 2005 environment (Source server)

Windows 2003 SP2, TFS 2005 with SP1, SQL 2005 RTM or later, WSS 2.0 SP2

TFS 2010 Environment (Destination server)

Windows 2003 Sp2, TFS 2010 RC, SQL 2008 RTM, WSS 3.0

Upgrade process:

This will be an in-place upgrade of TFS. As TFS 2010 will not support SQL 2005 and WSS 2.0, before we can upgrade TFS 2010, we have to upgrade SQL 2005 to SQL 2008 and WSS 2.0 to WSS 3.0. So the whole upgrade process is a threefold process.

1) Upgrade SQL 2005 to SQL 2008 (upgrade all the SQL components), Upgrade steps can be found on the MSDN documentation here: http://msdn.microsoft.com/en-us/library/ms144267.aspx

2) Upgrade SharePoint from 2.0 to 3.0. We have a detailed blog on doing a side-by-side upgrade of WSS 2.0 to 3.0 by Lakhminder, you can find the content here: http://blogs.msdn.com/lakhminder/archive/2008/07/08/upgrading-wss-2-0-to-wss-3-0-after-a-tfs-upgrade.aspx. Follow the steps 1 thru 10 of this blog, under section “The side by side upgrade process would involve the following tasks:” Step 11 is not required. Once the web application is created and provisioned, you could uninstall WSS 2.0 from the box.

3) Configure Reporting services, you could drop the existing Reports databases and create a fresh set of databases for use with TFS 2010. The upgrade wizard would regenerate all the reports for the existing projects (in the same format as before). The user customizations will be lost.

4) Uninstall TFS 2005 from the server and run the TFS 2010 installation wizard. Uninstalling TFS 2005 uninstalls the binaries but the Databases are untouched. The TFS 2010 installation wizard will automatically start the upgrade, once the SQL server instance with the old TFS databases was pointed to.

Note: Also, delete the “Team Foundation Server” Site on port 8080, The TFS 2005 uninstallation will not perform this operation. This will cause a failure during the verification process. You would see an error similar to TF255297: The Web site found has bindings that conflict with the bindings chosen for the Web site for Team Foundation Server. You must manually resolve the conflict between the bindings.

Upgrade walkthrough:

1) After the first two steps from the above section is completed, Uninstall TFS 2005 from the server. Once TFS 2005 is uninstalled, Launch IIS and delete the “Team Foundation Server” site on Port 8080 and the associated application pool (TFS AppPool). Optionally uninstall the stale application pools and the central admin site for WSS 2.0 (SharePoint Central Administration). Start the TFS 2010 installation wizard.

clip_image002

clip_image004

2) Select the components needed to be installed on the server.

clip_image006

3) The installation would require Restart, proceed with the restart.

clip_image008

4) The installation phase completes, Launch the Configuration wizard.

clip_image010

5) In the Configuration wizard, select Upgrade

clip_image012

6) Click next to proceed

clip_image014

7) In the Upgrade Wizard, the SQL instance that hosts the TFS 2005 databases would be identified. Run the “List available databases”, the wizard would identify the valid integration database. Highlight the TFSintegration database and click next.

clip_image016

8) Enter the TFS service account and proceed

clip_image018

9) Accept the default for the Web site and IIS virtual Directory settings and proceed

clip_image020

10) Select the checkbox to configure reporting services. Again, you don’t need the old Reports databases. At the same time, you need to have a pre-configured reporting services dedicated for TFS 2010.

clip_image022

11) Populate the URL for reporting service configuration and validate the URL by browsing to the url on a browser.

clip_image024

12) Enter the SSAS instance name and proceed.

clip_image026

13) If you need to use a separate reader account for reports (similar to TFsreports used in TFs 2005), you can do so, or ignore the screen and proceed.

clip_image028

14) Select the check box to configure SharePoint. Note: SharePoint should be upgrade to WSS 3.0 if not done earlier. Check point 2 of the Upgrade process section above.

clip_image030

15) Validate the url’s captured by the upgrade wizard by clicking test and proceed

clip_image032

16) Enter a name for the Project collection that will be created in your TFS 2010. Project collection will contain all your TFS 2005 projects within.

clip_image034

17) Confirm the settings before the verification begins.

clip_image036

clip_image038

18) Start the verification.

clip_image040

19) The verification process identifies errors and warning. You should fix the errors before proceeding further. In this scenario, we see an error as I wanted to show you what happens if the old Team foundation server web site on port 8080 is left undeleted. You could see the error message in the log attached below.

clip_image042

clip_image044

20) After deleting the web site on port 8080, within IIS you could rerun the verification again. See the verification successful this time.

clip_image046

21) Continue to configure the upgrade.

clip_image048

22) The upgrade phase follows

clip_image050

23) Once the upgrade succeeds, close the wizard, this automatically launches “Team Foundation Server Administration Console”

clip_image052

clip_image054