Problem description:
We have multiple webreports servers and are looking for an automated
way to export the scheduled tasks / security / custom reports / etc from
one webreports server and import them into another (a DR server). Is there a tool or
some DB script we could do this with?
I opened a PMR with IBM who asked me to open an RFE. I thought I’d also check here.
Just so you know, RFEs are long term things… something that you should expect to see in the 6 months to 3 years time frame, and that assumes that it is actually chosen to be accepted and worked on.
In this case your best bet is the forum and getting help from others that have the same issues and getting guidance from IBM Developers that might have some insight to help do this.
Thanks JGStew. Hopefully others in the community have some insight into a solution for this. It seems like it should be a common request.
I would look into any guides that may talk about migrating web reports servers, that may give some insight into what is required.
It might be possible to just entirely replicate the DB.
If the second Web Reports instance really is for DR, you can essentially backup/restore the BESReporting database which itself maintains the elements you’ve described above (users, reports, filters, scheduled activities, etc…). You may also want to backup/migrate the output of scheduled activities as well which is stored in the filesystem: [BigFix Server folder]\BESReportsData\ArchiveData.
Aram, if there is WebReportsA and WebReportsB (A is the Primary, B is the DR) and A points to the primary root servers and B points to the DR root servers, wouldn’t copying the WebReportsA database on top of the WebReportsB database overwrite the datasources that are unique to WebReportsB?