TFS 2010 Upgrade simplified (best practices, caveats and FAQ)


1. Install SQL 2008 R2, (SSAS,SSRS (install and configure reporting services in native mode)

2. Run the pre scan tool in the WSS 2.0 environment and once it succeeds back up the following content database and restore it in the new SQL 2008 R2 environment

a. STS_Content_TFS

* Step #2 is applicable only if you are in WSS 2.0

3.  Make full backup of the following six TFS databases (including Transaction log) and Shrink the

databases using SQL management studio

· TfsActivityLogging

· TfsBuild

· TfsIntegration

· TfsVersionControl

· TfsWorkItemTracking

· TfsWorkItemTrackingAttachments

4. If you are using custom reports please make sure to back up following databases and encryption key

· Report Server

· ReportServerTempDB

5.  Also make sure to back up the SharePoint content database

· WSS_Content

(If you have upgraded from TFS 2005 this database name will appear as STS_Content_TFS, i.e if you are upgrading from WSS 2.0, you need to run Prescan tool before making backup of the STS_Content_TFS database on the old WSS2.0 server)

6. Check for triggers on any of the “Tfs...” named SQL databases listed above. The TFS databases should *not* have any triggers. If any found, drop them from the database.

NOTE: Database triggers only. Do not mess with any table triggers.

How to check the trigger presence?

a. Open SQL Server Management studio and connect to the SQL database engine

hosting your TFS databases.

b. Click on the plus sign to expand databases

c. Expand the “TFS...” named database

d. Expand programmability

e. Click on database triggers

This will show any triggers in the right-hand reading pane. If there are any present, delete them.

7. What is required in the Target Machine?

Application Server (Application Tier)

1. IIS 7 or latest with IIS 6 compatibility and management tools

(With and windows authentication enabled)

2. Reporting Services installed and configured with Native mode (SSRS)

3. If none of the SQL components such as SSRS are present on the app server, please

make sure to install the SQL Client components in the application Tier

4. Install WSS 3.0 Sp2 / SharePoint Foundation 2010 /SharePoint server 2010 with Enterprise features

- Create a web application and create a root site collection

(This process will create a new content database – name it as


Data Server (Data Tier)

1. Install SQL Server 2008 Sp2 / SQL server 2008 R2 Sp1 (SSDE ) along with Analysis

Services (SSAS)

2. Add the TFS Setup account as Sysadmin on SSDE and SSAS

8.  Restore the database backed up in Steps (1 – 3) on the Target SQL instance

      (If there aren’t any custom reports, do not restore ReportServer and ReportServerTempdb databases )

9.  Open SharePoint central administration and go to Manage content databases, and remove the Content database WSS_Content_Remove_Me and attach the content database  restored from the

TFS 2008/2005 server ( it may be either called as WSS_Content or STS_Content_TFS)

10. Install TFS 2010

11. Please make sure KB2135068 is installed before proceeding to choose upgrade wizard

                - Click on Configure installed components

                - select upgrade

                - Specify the SQL server name

                - URL’s for reportserver and Sharepoint

                - specify the TfsService account where appropriate

12.   Verify the installation by creating a collection database and Team project


1. Can we connect to TFS 2010 server using Visual Studio 2005 / 2008 client without any issues or are there any known issues?

Yes! You can connect using Vs2005/2008 Team explorers, there is a forward compatibility update available, and you need to install the following after applying the Sp1 on the clients (Visual studio 2005 /2008)

Visual Studio Team System 2005 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010 (Installer)

Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010 (Installer)

2. Can we connect to TFS 2005 server and TFS 2010 server using a single Visual studio client (switching between servers)? Are there any issues with this?

Yes! It is possible.

3. Does the upgrade removes the TFS security ( user permissions configured on the old version environment)

No! It does not remove any user privileges in the TFS security

4. Does the customized process templates get upgraded /Migrated to the new version

The projects created using the customized process templates are also upgraded

5. I have used custom SharePoint template ( or 3rd party like scrum), will the upgrade take care of it?

It is not taken care by TFS upgrade, customized SharePoint site templates or 3rd party site templates need to be addresses separately, it's not within the purview of TFS upgrade, but this will not be a blocker for TFS upgrade

6. Does TFS 2010 works with SharePoint 2010

Yes! It does work with all editions of SharePoint 2010

7. Does TFS 2010 upgrade, upgrades my custom reports as well

Be it custom reports or stock reports, neither of them are upgraded in TFS 2010. You can gracefully omit the reports backup and restore since TFS 2010 upgrade will provide a new set of stock reports for all the existing old projects

Content developed by : Vimal

Content reviewed by : Lakhminder Singh

Comments (0)

Skip to main content