Rules

Secret ingredients to quality software

Edit
Info

Do you know how to upgrade your TFS2008 databases?

Last updated by Christian Morford-Waite on 26 Feb 2021 05:05 am (2 months ago) See History

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
    01 TFS Config   Upgrade
    TFS Config - Upgrade
  6. Click "Next" 02 TFS Upgrade Wizard   Upgrade
  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" 03 TFS Upgrade Wizard   Databases
  11. Select "NT AUTHORITY\NETWORK SERVICE" for the System account
  12. Click "Next"
    04 TFS Upgrade Wizard   Account
    TFS Upgrade Wizard - Account
  13. Click "Next"
    05 TFS Upgrade Wizard   Application Tier
    TFS Upgrade Wizard - Application Tier
  14. Click "Next"
    06 TFS Upgrade Wizard   Reporting
    TFS Upgrade Wizard - Reporting
  15. Click "Next"
    07 TFS Upgrade Wizard   Reporting   Reporting Services
    TFS Upgrade Wizard - Reporting - Reporting Services
  16. Click "Next"
    08 TFS Upgrade Wizard   Reporting   Analysis Services
    TFS Upgrade Wizard - Reporting - Analysis Services
  17. Specify the TFSService account
  18. Click "Next"
    09 TFS Upgrade Wizard   Reporting   Report Reader Account
    TFS Upgrade Wizard - Reporting - Report Reader Account
  19. Click "Next"
    10 TFS Upgrade Wizard   Sharepoint
    TFS Upgrade Wizard - Sharepoint
  20. Click "Next"
    11 TFS Upgrade Wizard   Sharepoint   Settings
    TFS Upgrade Wizard - Sharepoint - Settings
  21. Click "Next"
    12 TFS Upgrade Wizard   Project Collection
    TFS Upgrade Wizard - Project Collection
  22. Click "Next"
    13 TFS Upgrade Wizard   Review
    TFS Upgrade Wizard - Review
  23. Click "Configure"
    14 TFS Upgrade Wizard   Readiness Checks
    TFS Upgrade Wizard - Readiness Checks
  24. Have coffee (2 hours)
    ssw coffee
    Coffee
    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]
    15 TFS Upgrade Wizard   Configure   Upgrade Process
    TFS Upgrade Wizard - Configure - Upgrade Process
  25. Click "Next"
    16 TFS Upgrade Wizard   Configure   Upgrade Process Success
    TFS Upgrade Wizard - Configure - Upgrade Process Success
  26. Click "Close"
    17 TFS Upgrade Wizard   Complete
    TFS Upgrade Wizard - Complete
  27. Click "Close"
    18 TFS Config   Application Server Complete
    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
redbull
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
Adam CoganAdam Cogan
Eric PhanEric Phan

We open source. This page is on GitHub