Scenario : Source SQL Server Reporting Instance : SQL Server 2008/12/14/16 Destination SQL Server Reporting Instance : SQL Server 2008/12/14/16 Solution : There are two methods for the migration of reporting server from One instance to another. The easiest method and the hardest method. You may choose the hardest method if you want to consolidate multiple report servers into single. And if you are willing to have multiple report servers in your environment, go ahead with the easiest method. 1) Easiest method : Database Migration 2) Hardest method : Reports Migration 1) Easiest method : Database Migration Setps to follow : Backup the Source Reporting Server Databases : e.g. ReportServer and ReportServerTempDB Backup the Encryption key from Source Reporting server instance Restore the Database on destination reporting server SQL Instance (Not required if you want to keep the existing Database server same. Restore the Encryption key on Destination Reporting se
