SSRS

SSRS Migration

SSRS Migration

Objective:

SQL Server Reporting Services Migration Tested from SQL Server 2008 to SQL Server 2016 steps are noted in the below. This will make the content of the SSRS to move to another server easily.

Below web-link information is the best for migrating the SSRS and further migration options are also noted for the user benefit.

Reference:
https://docs.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers

The below URL has the download link for ssrs_migration.rss scripts

https://azuresql.codeplex.com/releases/view/115207

Please keep the ssrs_migration.rss file in the folder and then go to command prompt and change the directory through command prompt where the ssrs_migration.rss script exists and then run the below to achieve your migration. Please note that you need to replace the source and target based on your requirement.

The above will suffice to copy the SSRS contents from one server to another server.

There is a another method, recently used when there is no connection between source and target SSRS Server. I have achieved to download all the .RDL files from SQL Server 2000 Reporting Services to SQL Server 2016 SSRS.

Step I:

Please keep the rss file in the folder. The filename like DownloadRDL.rss

2. Step II

Prepare the below file as batch file or you can run through command prompt

Once you executed, all the RDL files from the source server (http://sourceserver/reportserver) will be delivered to the C:\SSRSMigration\RDL_Files\ folder.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *