Upgrading TFS to 2010

Upgrading TFS to 2010

Posted by Simon Reindl | November 12, 2010 | Best Practice, Microsoft, TFS 2010, Visual Studio ALM

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  http://www.msteched.com/2009/Europe/DEV311.


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:


Topic Link
The TFS upgrade guide http://vs2010upgradeguide.codeplex.com/
Upgrade options http://blogs.msdn.com/b/bkrieger/archive/2009/10/21/team-foundation-server-2010-upgrade.aspx
How to Upgrade http://blogs.msdn.com/b/bharry/archive/2009/10/21/upgrading-from-tfs-2005-2008-to-tfs-2010.aspx
TFS Config command overview http://msdn.microsoft.com/en-us/library/ms253116(VS.100).aspx
TFS Config Import command details http://msdn.microsoft.com/en-us/library/ff407080.aspx


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.

Related Blogs

Posted by richard | September 30, 2016
Wassup Team Room?
According to Microsoft's official definition, Team Rooms, like chat rooms, "provide teams with a space to discuss work in progress, ask questions, share status, and clarify issues that arise." Sounds...
Posted by richard | November 4, 2015
Microsoft, please give us a Scrum process template
In 2014, the Scrum Guide was moved off of Scrum.org and posted to ScrumGuides.org. At the same time, all of the major Scrum organizations in the world acknowledged this as...
Posted by richard | February 24, 2015
Use Excel to Create Repetitive Work Items
Teams often ask me for any shortcuts to periodically creating the same work items, such as for each sprint or release. In other words, they want to create the same...