Importing a single report from SSRS 2016 to SSRS 2019

efg20 6

Hello, we currently have a windows 2012 virtual server running SSRS 2016 that is currently in production and a windows 2019 virtal server running SSRS 2019 that will be replacing it. We would like to know if there is a way that we can export a single report from the SSRS 2016 server and import it into the SSRS 2019 server without having to move/migrate the report server database. Any advice would be greatly appreciated. Thank you.

efg20 6 Reputation points

2021-07-16T04:18:13.303+00:00

I just came across this article. Is this how it can be done?

https://learn.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers?view=sql-server-ver15
Joyzhao-MSFT 15,586 Reputation points

2021-07-21T07:30:13.18+00:00

Hi @efg20 ,
Has your issue been resolved?
If you have any questions.please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy

1 answer

Joyzhao-MSFT 15,586 Reputation points

2021-07-16T06:27:40.143+00:00

Hi @efg20 ,
This Microsoft Page “Sample Reporting Services rs.exe Script to Copy Content between Report Servers” describes a sample script created by Benjamin Satzger at Microsoft, to migrate content between two Report Servers using the rs.exe application present in both modes of Reporting Services installation.

But if you just want to move a report, I suggest you download the report to a local folder from Report Manager, and copy it via email or U disk. The rs.exe script is suitable for batch report transfer.

Best Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
Joyzhao-MSFT 15,586 Reputation points

2021-07-16T06:35:59.583+00:00

In the same way, when you copy the report to other servers via email, etc., you only need to upload it in the Report Manager.

efg20 1 Reputation point

2021-07-16T17:13:10.317+00:00

Thank you for this information. It seems easy enough. Can this be done for an .rdl file from SSRS 2016? I just tried to upload 2 different .rdl files to SSRS 2019 that I downloaded from SSRS 2016; but I receive the following error (see attachment):

"An error has occurred. Something went wrong. Please try again later."

efg20 1 Reputation point

2021-07-16T18:13:59.683+00:00

I just resolved it. I changed the SSRS service account from the built-in one to a windows domain user account and it worked just fine. Thank you for the quick response.

Joyzhao-MSFT 15,586 Reputation points

2021-07-19T01:29:01.813+00:00

Hi @efg20 ,
Sorry for the late reply. If the answer is helpful, please click "Accept Answer" and upvote it. Thanks for your understanding.
Best Regards,
Joy
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Importing a single report from SSRS 2016 to SSRS 2019

1 answer

Your answer