Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

What is the process for migrating the Report Builder (RS) database from one server to another?

Questions
Tags
Users
Badges
Daniel Barbour
(250●3●23) edited
Nov 11 '16, 4:02 p.m.
[Currently using CLM 6.0.2]

The help information provided in https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Ft_migrate_dbs.html does not cover the Jazz Reporting Service application Report Builder.  Therefore after the data migration has been completed we discovered that none of the user/custom report templates created for Report Builder were available on the new server.

I was able to restore these by manually copying the /rs/db folder from the original server to the new server but this was only possible because (at least for now) the RS database is stored locally (vs in our SQL Server database). 

[Updated: Would this procedure work (copying the /rs/db folder to the new server) if the target server was hosted on a different OS from the OS used for the source: That is, could I copy the folder from a server using Windows Server 2012 to one using IBM AIX?]

First question: Is there a different procedure that I can be used (similar to the repotools export/import steps, or the LDX/LQE backup steps)?

Second question: Can the data migration of the Report Builder database be made similar to one of the others?

Lastly - At a minimum can the Help information be updated to include Report Builder?

0 votes

Comments
Daniel Barbour
Jan 12 '17, 2:41 p.m.

 For other readers:

Copying the /rs/db folder from the original server (in Windows Server 2012) to the target server (in Red Hat Enterprise Linux 6.8) did, in fact, work. I have not tried this to an AIX environment but given the RHEL experience I would not expect a problem.

For IBM: As a user I would still prefer that a defined method (preferably similar to that used for LDX/LQE database backup/restore operations) be implemented.

1 vote

0 answers
2,343 views
0 votes

Be the first one to answer this question!

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 7,495

Question asked: Nov 11 '16, 9:55 a.m.

Question was seen: 2,343 times

Last updated: Jan 12 '17, 2:41 p.m.

Confirmation Cancel Confirm