© Defacto 2018
Simplify Business Intelligence
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.
Enter connection details for source and destination servers
On the source server all items below the Root folder are migrated. The destination root folder is where items are migrated to.
Most items there is a create and update option. This gives the option to
For a successful migration some things need to be entered. All these items can be bulk changed.
Change the subscription delivery. Upgrade subscription rendering eg .doc > .docx, .xls > .xlsx
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.
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
Start the migration this will take a matter of minutes. Go and get a coffee and come back to a migrated SSRS Server!