Replicate SSRS Reports for Test


(John Mitchell) #1

Is there a tool or script we can use to replicate our Production Reports to Test when we restore a SQL backup? Thanks, John


(Jose C Gomez) #2

in 10.1.X you should be able to use Solution Workbench


(John Mitchell) #3

Thanks so much!

I found some scripts with Microsoft but they seem to be more for multiple servers instead of folders inside a single server.

https://docs.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers


(Jose C Gomez) #4

Also this works, (sort of)
https://code.google.com/archive/p/reportsync/
It will copy the RDL’s but you’ll have to adjust the datasets manually.


(John Mitchell) #5

It looks like what I want exists but I need to upgrade to SQL 2016/2017 to get the REST API’s in SSRS.