With the change from TFS 2008 to TFS 2010, with the introduction of the TFS collections, Microsoft completely reorganized the database structure. This makes it impossible to just attach your TFS 2008 databases to an existing TFS 2010/2012 environment. You can not attach a collection as the concept of a collection didn’t exist yet in 2008.
So how can we fix this?
Luckily Microsoft did all the work for us and introduced a command line option in TFSconfig to import an old TFS 2008 database and attach it as a new collection.
- Export the TFS 2008 databases
- Import the databases to the database server that you use for your TFS 2012 instance
- Log on to your TFS 2012 application server
- Open a command prompt(run as an administrator)
- Go to the TFS tools directory: c:\program files\Microsoft Team Foundation Server 11.0\Tools
- Run the tfsconfig command with the following options:
- tfsconfig import /SQLInstance: <instancename> /CollectionName: <new collectionname> /confirmed
- This will start the upgrade process. Be patient as this can take some time.
- When everything ran successful, you should see a message telling you there are 0 errors and 0 warnings.