© Defacto 2018

Contact us

Simplify Business Intelligence

Home

2ndRock

Home Software Download Purchase Support

SSRS Migrate and Deploy

Since SSRS was released with SQL 2000, there has never been an automated way to migrate SSRS to a new server.


SSRS Migrate and Deploy features.


  1. Supports SSRS 2000- 2017, Power BI on premise.
  2. Migrating to a different SSRS mode- Native or Integrated (SharePoint) both ways supported.
  3. Backward compatible (with exception of reports). Migrate items to an older SSRS version.
  4. Health check before migration. Know what will fail before the migration.
  5. Partial Migration or deployment.
  1. Option to choose on a per item basis
  1. Visually see the differences on the source and destination SSRS servers.
  2. Selective migrate and deploy. Eg. deploy only reports, subscriptions, data sources and data sets.
  3. Resilience. SSRS Migrate auto retry on SSRS commands. If a command fails then retry.
  4. Migrates
  1. Logging migration information. Detailed logging for each item migrated.


5 Steps to Successful Migration

1. Connect to Source and Destination servers


Enter connection details for source and destination servers

2. Select Root Folders

On the source server all items below the Root folder are migrated. The destination root folder is where items are migrated to.

3 Select Items to Migrate


Most items there is a create and update option. This gives the option to

4 Health Check and Transformation

For a successful migration some things need to be entered. All these items can be bulk changed.

Example transformations

Change the subscription delivery. Upgrade subscription rendering eg  .doc > .docx, .xls > .xlsx

Example transformation

Identify issues between source and destination servers prior to migration. Here you can see the Oracle connector is not on the destination server. Data sources with Oracle will fail on the migration. Lets assume you have migrated from Oracle to SQL Server. In this case all the data sources need to be changed. Which can be done in bulk. Search and replace by connection type, connection string and username/password.

Identify SSRS Issues

SSRS Migrate identifies orphaned item issues. We cannot fix these you will need to manually fix them before the migration. Orphaned items occurs when the dependant item is deleted. If doesn’t work on the SSRS source server it will not migrate to the destination server

Examples where this can occur


Below you can see examples of an orphaned dataset and orphaned linked report

5 Migrate

Start the migration this will take a matter of minutes. Go and get a coffee and come back to a migrated SSRS Server!