SSRS DB back up and Restore

Kinetic ERP
1

We are going live and changing a few environments around. I know best practice is to use solution files which we are going on go live. After we go live we are going to copy production to out DEV environment. The RDL files will not be in the new environment is it ok to back up the SSRS Prod DB and restore it to SSRS Dev?

2

Epicor just uses the report database as temporary holding during report generation. The RDL files are in the ERP database.

3

i was kind of thinking something like that but I could not remember. I really don’t want to do a solution file to get all the rdls to install but I guess I won’t have much choice. Is there an easier or better way to just move them over so when I go in SSRS i see all the custom reports. Basically I just need the CustomReports folder.

4

I always work in dev and then solution to test then solution to live, so I am always in sync.

Making a complete solution is not too bad. Search for report styles over 1000 and I think I ran into a limit of 300 reports per solution.

I know @josecgomez had an offline report mover, but I have not kept up with it.

5

I always do that too but since we are making a lot of changed the DB itself will be correct but all my reports will not be there.

6

You can use something like this to export the custom folder and import to another server.

Reportsync

You can find it in the Google archives
https://code.google.com/archive/p/reportsync/downloads

7

Correct that the EpicorReports DB is just temporary (also consider archived reports), but actually the RDLs live in the SSRS Database (ReportServer DB, Catalog table) as BLOBs. They are represented as files when browsing /reports and you can export from there to .RDL as well.

Solution files as you suggest is the best way to do it. The data source links get resolved doing it this way.

ReportSync as suggested by Chris is OK as well, I’ve used that.

2 Likes
8

ok thanks. I will check out Report Sync.

9

Can you tell me is this just installed on your local pc? or does it need to be on a server?

Thanks

10

https://code.google.com/archive/p/reportsync/wikis/Introduction.wiki

You can run it from your pc, and provide credentials to authenticate against the SSRS server.