A couple of weeks ago I did an upgrade of a customer’s TFS 2008 installation.
The pre-requisites for the assignment was:
- Migrate from single server 2008 SP1 TFS to dual server setup of TFS 2010
- New hardware
- WSS 3.0
I was fortunate to run into one of my many great colleagues when attending Techready in Seattle, Lakhminder is one of our Support Escalation Engineers specialized on TFS and he helped me do a rough outline of the steps involved in the upgrade process. I have augmented the process slightly and thought I would share it with you.
Please note that this is a high level description and that it is provided as is, you have to test and adapt it to your scenario.
1. Set up the new 2-tier Server 2008 based systems. Install SQL +SSAS on the DT. Install RS +WSS 3.0 on the AT.
2. Restore the RS(ReportServer + RemportServerTempDB), WSS_Content(no need to restore the Config & Admin Content ds) and the TFS 2008 dbs on the target DT Server 2008 machine.
3. Restore the backup of the SSAS TfsWarehouse db(it gets backed up as a bkf file & you should back it up with no compression & without password to make things easy for you during restore) on the target SSAS instance on the server 2008 machine.
4. remove the old RS using RSKeyMgmt -r <old guid>
5. Configure RS on the TFS app-tier, ensure that you have updated the data source with the new SQL Server machine names in their connection strings in the TfsOlapReports & TfsReports data sources.
6. Install WSS 3.0
7. Change account on the default AppPool to Network Service
8. Extended the default web site with WSS or create a new one and attach the content db with the TFS 2008 site collection sitting on the target SQL Server DT Server 2008 machine. Make sure you are able to browse site collections.
9. Install TFS 2010 on the new AT.
10. Grant rights to the RSExecRole according to this post http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/444c3bab-985b-40a0-8362-2742df1a6577
11. Use the “Upgrade” option in the configuration wizard to upgrade TFS 2008 dbs to TFS 2010.
Lakhminder also pointed out a couple of things to note:
We re-released the shipping media for TFS 2010 because of a bug that impacted users upgrading from TFS 2005/2008. This post has the details to check if you are using the latest media.
TFS 2010 upgrade wizard will allow you to skip Reporting & SharePoint settings as part of the upgrade. While you can opt out of SharePoint at the time of upgrading TFS, but **do not leave Reporting**. It’s very hard to get reporting to work after an upgrade to TFS 2010 is done.