Move SSRS Reports from one reportserver to another

Question

Is there a way to move/copy SSRS reports from one server to another with the folder structure and, etc.?

Can I just copy what's in catalog table and add it to catalog table under a new server?

The reason I am looking for a solution like this is because there are over 200+ reports on the current reportserver with several folders, data sources and subscriptions. I'd like to save time if that is possible.

Check [this](https://msdn.microsoft.com/en-us/library/dn531017.aspx#bkmk_supported_scenarios) utility, it could help you. — alejandro zuleta, Apr 20 '16 at 20:37

score 2 · Answer 1 · edited May 23 '17 at 12:31

2

You can try reportsync tool which is needed to migrate the SSRS reports from one server to another. Give it a try. I have tested this successfully in my environment in the past.

Check this link too for more details: SSRSReports

Hope this helps you!

edited May 23 '17 at 12:31

Community

1
1

answered Apr 20 '16 at 20:40

Navneet Sharma

98
9

score 1 · Accepted Answer · edited Jun 20 '20 at 09:12

1

Use Report Sync - You may need to change some code if it may not work on your environment.

Use Sync button to update same report on different server.

Use Upload button to upload all selected report to particular folder on different server.

Use Download button to download all reports to local drive.

Please let me know, if you have any doubts/query or need any help regarding this.

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 21 '16 at 04:41

Pedram

6,256
10
65
87

This is a great tool. However, it is a must that we inherit which users created which reports. This is because we only support reports that were created by us. Also, it breaks data source connection. We have 300+ reports so it is bit annoying. Do you know any other process/tools who would accomplish this? – NonProgrammer Apr 23 '16 at 23:47
1

I'm also having 300+ reports and using same tool to deploy/sync on live server. I never get such data source connection error. I'm using hi-speed connection and you may need to change some code for time out operation. And if you're asking me for another tool then sorry I don't have any idea about same tool like this. But it is sure we can change the code as per our needs accordingly. Hope you understand what I'm saying... Have a great time and happy coding... Let me know if you need any other help. I have played on catalog database also so I may help you somewhere else also... – Pedram Apr 24 '16 at 07:59

Move SSRS Reports from one reportserver to another

2 Answers2