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.

(Jose C Gomez) #4

Also this works, (sort of)
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.