Upgrade TFS 2010 to TFS 2012 with Migration to a New Hardware – Part 5 – Restore DBs and Reporting Encryption Key

In this blog series I start to explain step-by-step tutorial on how to upgrade existing TFS 2010 to TFS 2012 Update 1 with the migration to a new hardware, the series will include videos and images as well. In the last post I will include one video that collect all parts for one-shot view, this series consist of following parts:

Each part consist of one or many sections as needed.


Part 5 – Restore DBs and Reporting Encryption Key

  • Run TFS 2012 Restore Tool and restore old DBs to the new SQL server 2012.
  • Change Reporting DB and restore Reporting Encryption Key.

The following is the video that explain this blog post.


Run TFS 2012 Restore Tool and restore old DBs to the new SQL server 2012.

In this section I will explain how to restore the backup DBs to the new SQL Server 2012 using the new tools TFSRestore.exe.

Get back to the command line on the new machine (TFS 2012), type TFSRestore and then enter.46-Run-TFSRestore

The TFS restore tool will launch.47-Connect-TFS12UP

Click Connect and in the Select Backup Location, add the shared folder that has created earlier and now has all backup files, select all DBs, we must check Overwrite the existing database(s) this to replace the existing Reporting Service DB, otherwise the restore will fail.48-Add-shared-folder-of-DBs

Review the success of the restore.49-TheData-Restored-successfully

Change Reporting DB and restore Reporting Encryption Key.

Open the Reporting Service Configuration Manger.50-1-Open-Report-Service-Config-on-TFS2012

Click Connect to the new server (TFS12UP), after that click on Database tab and then click on Change Database.50-Click-Database-change

Select Choose an existing report server database and then click Next.51-Choose an existing report

Test the connection to server and then click Next.52-test connection

Select the Report Server database from the drop down and then click Next.53-select-report-server-db

In Authentication Type, leave the default (Service Credential) and then click Next.54-select-service-credentials

In Summary, review and click Next.55-summary

Review the success of changing the DB.56-change-report-DB-success

Click on Encryption keys tab and then click on Restore button, select the shared folder path that has the backup key, type the password that we used during the key backup and click OK.57-Restore-key

Review the success of restoring the key.58-MakeSure-Restore-success

Click on Scale-out Deployment, select the old TFS machine (TFS2010) and click on Remove Server, if you have the same error as me, you will need to remove that manually.59-Try-to-remove-TFS2010-from-Scale-out

Go to the SQL Server RSKeyMgmt Tool folder and copy the path “C:Program Files (x86)Microsoft SQL Server110ToolsBinn“.60-copy-path-of-key-tool

Open the command line tool as Administrator, type cd and paste the path of the tool.61-type-cd-past-folder-path

Type RSKeyMgmt –l to list all server with their GUIDs.62-Run-RSKey-list-all

Copy the GUID of the old server (TFS2010), type RSKEMgmt –r  and paste the GUID to remove this server, after that, list again to make sure that server was successfully removed.63-remove-with-GUID

Review the Scale-out Deployment, to make sure it’s removed.64-make-sure-it-removed

Share This: