Do you know how to upgrade your TFS2008 databases?
  v5.0 Posted at 12/08/2012 4:08 AM by Tiago Araujo
Since we recommend doing a "move based upgrade", we don’t like the "in place upgrade" option, these are the steps:
  1. Copy the TFS2008 backups to TFS2010 server (e.g. C:\TfsBackups)
  2. Restore all the databases to TFS2010’s instance of SQL 2008
  3. Install Team Foundation Server 2010
  4. After the install has completed the Team Foundation Server Configuration Wizard will open
  5. Select Upgrade | Start Wizard
    TFS Config - Upgrade
  6. Click "Next"
  7. Click "List Available Databases"
  8. Select the TfsIntegration database
  9. Check "By checking this box, I confirm that I have a current backup"
  10. Click "Next"
  11. Select "NT AUTHORITY\NETWORK SERVICE" for the System account
  12. Click "Next" 
    TFS Upgrade Wizard - Account
  13. Click "Next"
    TFS Upgrade Wizard - Application Tier
  14. Click "Next"
    TFS Upgrade Wizard - Reporting
  15. Click "Next"
    TFS Upgrade Wizard - Reporting - Reporting Services
  16. Click "Next"
    TFS Upgrade Wizard - Reporting - Analysis Services
  17. Specify the TFSService account
  18. Click "Next"
    TFS Upgrade Wizard - Reporting - Report Reader Account
  19. Click "Next"
    TFS Upgrade Wizard - Sharepoint
  20. Click "Next"
    TFS Upgrade Wizard - Sharepoint - Settings
  21. Click "Next"
    TFS Upgrade Wizard - Project Collection
  22. Click "Next"
    TFS Upgrade Wizard - Review
  23. Click "Configure"
    TFS Upgrade Wizard - Readiness Checks
  24. Have coffee (2 hours)
    BTW: A good user interface should have a coffee image
    [TODO: Martin to create new rule in "Rules to better UI"]
    [TODO: Martin to add suggestion to TFS]
    TFS Upgrade Wizard - Configure - Upgrade Process
  25. Click "Next"
    TFS Upgrade Wizard - Configure - Upgrade Process Success
  26. Click "Close"
    TFS Upgrade Wizard - Complete
  27. Click "Close"
    TFS Config - Application Server Complete
  28. Change the DNS entry for tfs.northwind.com to point to TFS2010 on
    1. Internal DNS
    2. External DNS
    Red Bull Can Since you have to deal with your system admins, this job will take the longest. Speed it up by buying a Red Bull for your system admin

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:


    Note: Social Media login for Yotpo is not working in IE or Safari, please use Chrome. We are waiting for Yotpo to fix it.