At TechEd Europe 2010, I had the privilege to work on the VS2010 Ultimate booth. It was great to meet so many folk, and find out how different people were using TFS and VS2010.

One recurring question was about upgrading, and the ways to do it.

Neno Loje delivered a great talk about administration of TFS, in which he covered a range of topics, including upgrading. I recommend watching the recording to check how you are doing. The recording is at


He recommended an approach that will import the previous version in to a new instance of TFS. The advantages of this is that you can move to a 64 bit application tier, and have the certainty that the new instance is up and running before importing the existing data.

Recommended Reading

The devil is in the detail, and it is well worth reading up on the upgrade process:


The TFS upgrade guide
Upgrade options
How to Upgrade
TFS Config command overview
TFS Config Import command details


Step Summary

  1. Create the new instance of TFS with all the correct configuration, preferably on 64 bit Application Tier connecting through to the database.
  2. Then configure and test the new instance to ensure that you can see the work items, reports etc.
  3. Then copy a backed up version of your databases over to the new sql server
  4. Then import the old databases using the command line (you need to open a command prompt as an administrator, and navigate to the tfstools folder), this example was taken from the Brian Harry Blog Link.

Tfsconfig import /connectionString:”Data Source=DT01;Initial Catalog=TfsIntegration;Integrated Security=SSPI” /collectionName:UpgradedCollection /sqlinstance:<SQL Instance Name>


This will import the existing TFS data in to a new project collection, and there may be some massaging required to correct any project template customisations, as well as reports.



Remember to try this in a test environment first, to ensure that the process is known before completing the production run.