TechNet
Export (0) Print
Expand All

Native to SharePoint Migration (SSRS)

 

Applies To: SQL Server 2016

You cannot upgrade or convert from one Reporting Services server mode to another. For example, you cannot upgrade or convert a Native mode report server to SharePoint mode. You cannot copy the report server databases between modes because they use different database schemas. You can migrate the content from one report server to another. The tools you use depend on the type of report server mode that is configured for the source and destination servers.

Applies to:  Reporting Services Native mode | Reporting Services SharePoint mode

The tool supports content migration from a native mode Deployment to a SharePoint mode deployment. The tool does not support migration from SharePoint mode to SharePoint mode or from SharePoint mode to Native mode.

For more information, see Reporting Services Migration Tool (http://www.microsoft.com/download/details.aspx?id=29560).

If the migration tool does not meet your needs, you can manually migrate the report server data. The following is a summary of the steps to complete to migrate report items from a one Reporting Services deployment ot another. The approach supports either Native or SharePoint mode as the source or destination servers.

  1. Backup and restore encryption keys. This is the key that is used to encrypt data. The encryption key is also used to encrypt passwords such as the passwords stored for data source connections. However, passwords cannot be migrated and you will need to enter them again in the destination environment.

  2. Reporting Services RSS scripts: Write a Visual Basic script that calls Report Server Web service SOAP methods to copy data between databases. Use the RS.exe utility to run the script. Rs.exe is installed with Reporting Services.

The following table summarizes the Reporting Services objects you can migrate with scripts:

ObjectCan be ScriptedComments
ReportsYesFollowing migration, to re-enter passwords for datasources.
DatasourcesYesFollowing migration, Re-link reports to datasources.
ModelsYes
DatasetsYes
Report PartsFollowing migration, verify or update the path to the report parts.
SchedulesYesSee the ListSchedules method Subscription and Delivery Methods
SubscriptionsyesSee the List Subscriptions method Subscription and Delivery Methods and the ChangeSubscriptionOwner method.
Snapshots
Show:
© 2016 Microsoft