Our TFS 2010 server was on a 32-bit Windows Server 2003 R2 box with SQL Server 2008. We are trying to upgrade to TFS2012. But the requirements of upgrade requires all 64-bit OS. So we have to move it to another 64-bit box. Since all our servers are virtualized on VMware already, it makes the migration process less pains. I found this migration guide.aspx) very helpful. And I was using VM snapshots to help me do the testing. Following are the brief of the steps I went through:

1) Install 64-bit OS Windows Server 2008 R2, and SQL Server 2008. Note: the SQL Server version and service pack/patch level needs to be exactly matched to the old server.

2) Install SharePoint 3.0 wth SP2 on the new box since we have SharePoint with TFS.

3) Stop the TFS 2010 service on old server: TFSServiceControl quiesce.

4) Backup and Restore all related databases following the migration guide. Don’t forget the database in Analysis Service.

5) Repoint the Sharepoint content database on the new box.

6) Change SQL Reporting Service databases, restore security certificates, and update the data source on the new box.

7) Install TFS2010 on the new box. Don’t run the config wizard yet. And update the TFS2010 to the same patch level as the old server.

8) Use TFSConfig PrepSQL to prepare SQL Server to be ready for TFS2010 on the new box.

9) Use TFSConfig RemapDBs to remap databases for TFS on the new box.

10) Use TfsConfig Accounts Update service accounts and accounts permissions on the new box.

11) On the new box, use Team Foundation Administration Console to start the Application-Tier Only wizard. After that, update the URL for the Application-Tier Server, Configure SharePoint products, and Configure Reporting and Analysis Services.

12) Add the new server to client’s visual studio, everything shows up exactly where it left.