Quick steps for a TFS 2010 upgrade.
One of our QA team members wrote up this quick step by step guide for doing a migration based upgrade to TFS 2010. These steps encompass some of the pre-req steps that you should follow when restoring the TFS, SharePoint and Reporting databases to a new set of servers when performing a migration based upgrade.
1. Backup TFS2005 or TFS2008 databases
a. TfsActivityLogging, TfsBuild, TfsIntegration, TfsVersionControl, TfsWorkItemTracking, TfsWorkItemTrackingAttachments
2. Backup Reporting Services databases
a. ReportServer, ReportServerTempDB
3. Backup SharePoint content Database (Only need the one with TFS content)
a. STS_Content_TFS ( or WSS_Content_TFS, or WSS_Content or STS_Content)
4. Install SQL Server 2008, SQL Reporting Services and SQL Analysis Services
5. Install Windows SharePoint Services 3.0 SP1
6. Configure SharePoint for Server Farm mode
a. Either Use the SharePoint wizard
b. Or the cmdline: (as Administrator, Change directory to (%commonprogramfiles%\MicrosoftShared\Web Server Extensions\12\bin”)
i. stsadm -o setconfigdb -databaseserver <datatier\instance> -farmuser <wssAccount> -farmpassword <wssAccountPassword>
ii. psconfig -cmd adminvs -provision -port 17012 -windowsauthprovider onlyusentlm
iii. stsadm -o extendvs -exclusivelyusentlm -url http://<machineName>:80 -ownerlogin <wssAccount> -owneremail "admin@localhost" -sitetemplate sts -description "Default Web Site"
iv. stsadm -o siteowner -url http://localhost:80 -secondarylogin <currentUser>
v. iisreset
7. Restore TFS databases to new data tier
8. Restore RS databases to new data tier
9. Configure Reporting Services to use restored RS databases using Reporting Services Configuration Manager
a. Connect to RS instance
b. Database page -> Change Database -> Choose an existing report server database -> Next -> Next -> [Select restored RS databases] -> Next -> Next -> Next -> Finish
c. Web Service URL page -> Change and then unchange the Virtual Directory textbox ‘ReportServer’ so the Apply button gets enabled. Click Apply.
d. Report Manager URL page -> Change and then unchange the Virtual Directory textbox ‘Reports’ so the Apply button gets enabled. Click Apply.
e. Encryption Keys page -> Click ‘Delete’ button to delete encrypted content. Click Yes to the popup.
10. Restore WSS Content database
11. Attach WSS Content database to SharePoint server
a. Open cmd window (as Administrator, Change directory to (%commonprogramfiles%\MicrosoftShared\Web Server Extensions\12\bin”)
i. stsadm -o addcontentdb -url http://<machineName>/sites -databasename <WssContentDatabaseName> -databaseserver <datatier\instance>
ii. stsadm -o addpermissionpolicy -url http://<machineName> -userlogin <currentUser> -permissionlevel "full control"
iii. iisreset
12. Install TFS2010
13. Select Upgrade Wizard
a. On Reporting Services page, Point to new RS instance
b. On Sharepoint Settings page, Point to new SharePoint server
14. After upgrade you will want to change the TFS instance GUID
i. net stop tfsjob agent
ii. iisreset /stop
iii. tfsconfig changeserverid /sqlinstance:<dataTierName> /databasename:Tfs_Configuration
iv. tfsconfig registerdb /sqlinstance:<dataTierName> /databaseName:Tfs_Configuration
v. iisreset /start
vi. net start tfsjobagent
