question

efg20-6054 avatar image
0 Votes"
efg20-6054 asked Joyzhao-MSFT commented

Importing a single report from SSRS 2016 to SSRS 2019

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.

sql-server-reporting-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @efg20-6054 ,
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

0 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
1 Vote"
Joyzhao-MSFT answered Joyzhao-MSFT commented

Hi @efg20-6054 ,
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.

115303-01.jpg

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.


01.jpg (64.6 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.
115296-02.jpg


1 Vote 1 ·
02.jpg (8.2 KiB)

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."

0 Votes 0 ·

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.

0 Votes 0 ·

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

0 Votes 0 ·