Replicate SSRS Reports for Test

Epicor ERP 10
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

2

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

1 Like
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.

1 Like
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.

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.