Reputation: 1387
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.
Upvotes: 0
Views: 3721
Reputation: 6508
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.
Upvotes: 1
Reputation: 108
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!
Upvotes: 2