Migrate SQL Server Reporting Services (SSRS) Deployments
There are different uses of the word "migrate" but in this context it refers to copying or moving your report server content and resources (shared subscriptions) from one report server to another. Common scenarios for this are... --> Upgrade: Upgrading your report server deployment, specifically you do not want to do an in-place upgrade but prefer to build out a new server environment with and migrate content from the old to new servers. --> Change Report Server modes: It is not possible to change an existing report server to a different mode, for example from native mode to SharePoint mode...so you can use the script to migrate your content and resources to a new mode. Common approaches to "migrate" include: 1) use script or a tool to copy items from one server to another. 2) Backup and restore databases that contain the report server items. The process is different for native mode and SharePoint mode.
04 Mar 2014
Upgrade and Migrate Reporting Services
Topic is an overview of how to upgrade and migrate SSRS report servers. The topic links to detailed topics specific to mode (native / SharePoint) and specific tasks you may need to complete.
Sample Reporting Services rs.exe Script to Migrate Content between Report Servers
The topic documents a script that empowers you to migrate your SSRS report items and resources from one report server to another. The topic links to a script that lives on CodePlex. The script works for both types of SSRS Report Servers, native and SharePoint mode.
Download Reporting Services Migration Tool from Official Microsoft Download Center
Great tool for some SSRS migrations scenario. The following is a summary of the scope of this tool: • Source and target server must be SQL Server Reporting Services 2008 R2 or later. • Source server must be native mode using Windows authentication. • Target server must be SharePoint integrated mode.
Step by step explanation and examples of the Reproting Services Migration tool
This article discusses how to use the Reporting Services Migration tool. The article covers the following aspects related to this method of migration. • Download location of the tool • Supportability of the tool • List of content migrated by the tool • Migration steps • Known issues with the tool (if any)
Migrating SQL Reporting Services to a new server by moving the Reporting Services databases
Great customer walking through of moving a native mode report server database. The content includes lots of screen shots.
Overview of the upgrade process to SharePoint 2013
regarding SSRS report servers in SharePoint mode, you cannot upgrade in place your SharePoint from the 2010 to 2013 version. To upgrade from SharePoint you use the database-attach method, which essentially means you first build out the basic SharePoint target environment and then copy content and service application databases.