SSRS Migrate Features Manual

© Defacto 2018

Contact us

Simplify Business Intelligence

Home

2ndRock

Home Software Download Purchase Software Support

SSRS Migrate and Deploy

50% off use discount code ONLYUNTILOCT15


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.


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!