Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

TFS tool used to help reduce downtime when upgrading to TFS 2015.

• Upgrading to Team Foundation Server 2015 can take a significant amount of time depending on the size of your database. Team Foundation Server has to be offline while the databases are being upgraded. TfsPreUpgrade.exe can be used to do the most expensive parts of the work to upgrade to Team Foundation Server 2015 while your Team Foundation Server 2013 deployment is still online, greatly shortening your offline time. We recommend running this tool for collection databases that exceed 1 TB in size.
  
  11/25/2015 Update: New version of TfsPreUpgrade posted which includes a fix for a performance issue related to pre-upgrading one of the TFS Build tables. Both the original version of TfsPreUpgrade.exe and this version are compatible with Team Foundation Server 2015 RTM and Team Foundation Server 2015 Update 1.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
README.txt SHA1: 5eeffffbe5ee43d143fd431f1389d97f3e43def4	711 bytes
TfsPreupgrade.zip SHA1: 1ee8a3e02a09d3a323d1d91898d28439c4ae523e	26.74 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Team Foundation Server deployments which:
  
  • Are currently on Team Foundation Server Update 4 or Team Foundation Server Update 5.
  • Have their relevant collection databases on an Enterprise edition of SQL Server.
  • Have their relevant collection databases on either SQL Server 2012 SP1 (or greater) or SQL Server 2014 CU3 (or greater).

• 1. Download TfsPreUpgrade.exe to a machine from which you can access the collection databases.
  2. Unzip it to a local directory.
  3. As a user who is a sysadmin on the SQL Server instance, run TfsPreUpgrade on your large (> 1 TB) TFS collection databases. You can run it on any smaller collection databases, but it’s not that helpful since the offline time for databases smaller than 1 TB tends to be short.
     TfsPreUpgrade.exe Run /TargetDatabaseNames:"{SQL Instance};{Collection Database Name}"
     You can specify more than one collection database using a comma-separated list of {SQL instance};{collection database name}.
     If you do, each collection database will be prepared in sequential order. If you want to run them in parallel, run theTfsPreUpgrade.exe command once for each collection database.
  TfsPreUpgrade.exe will run for quite some time, depending on the size of the collection database(s) that it is running against. It will report progress along the way so that you can have some idea of how far along it is and how much time might be left. Once TfsPreUpgrade.exe has completed, the triggers that it installs will keep any additional changes made due to the server being online flowing into the migrated tables. As such, there is no need to run it again before performing your offline upgrade to Team Foundation Server 2015.