reporting services - How do I copy SSRS reports to a new server if I am not the owner of the reports

Question

I have to copy all reports from one SSRS server to another. I plan on doing this by going through each report and downloading the report definition file and then uploading the file to the new server.

I have been given System Administrator and System User site wide roles and I have Browser, Content Manager, My Reports, Publisher and Report Builder roles for the Home folder but I still can't see the Edit button that will allow me to save the report definition file. The reason is because the reports are owned by other users. I can't ask all the users to give me permissions to edit their reports because there are too many users and I think a lot of them will never get round to doing it.

What can I do to copy all the reports to the new server if I am not the owner of most of them?

Answer 1

Try this tool: http://code.google.com/p/reportsync/

It can sync all reports(or selected folders) from one server to another. In addition you can also download to and upload from local folders.

Data sources with the same name will automatically get attached. Saves a lot of time as you don't have to reattach datasources after uploading.

Note: I wrote this tool myself to suit my needs, but its free and open source.