3

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.

1

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

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

1

Yes, doing that method you describe (I have done it myself) will leave your source environment fully operational and without issue. Any subscriptions you have in the source environment won't fully copy over unless you also copy the Agent Jobs from source to target though. .... although that may be what you want.

And if you are going to a different environment, do you want them pointing to the production database? You may want to just forget the encryption key stuff and leave the data sources broken if you are going to have to change them all anyways. All that moving the encryption key over does is allow the new environment to use the saved password information.

But you may also want to take this opportunity to add all your reports into source control (Visual Studio). Then you can just deploy from the project to whatever target server you want. There are powershell methods around somewhere (I think DBA Tools) that can help with this, extracting all the rdl files to a folder, for example.

0

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.

1
  • 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

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.