I am new to SSRS and I have been tasked to copy the SSRS reports(from PROD) to another Server(QA).

I found many documentations that show how to migrate the reports by Restoring ReportServer, ReportServerTempDB and encryption key.

I just want to confirm. After doing above, my main environment(prod) will remain intact and operational?Please confirm. I'm creating a QA environment that I am copying from PROD and I cannot afford for anything to happen to PROD.


You can right click on the report that you want to copy and choose the Download option. Download it to a file share and then upload it on the new site.

  • Thank you Paul for answer. There are hundreds of reports, data sources and I am doing this for multiple servers. This way will be too time consuming – user206573 Apr 14 '20 at 22:15

Microsoft makes a reporting migration tool. Reporting Services Migration Tool .

One drawback is that the Target server must be SharePoint integrated mode.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.