Steps for migration JAZZ and RRDI databases to SQL server 2012
We are currently at JAZZ 4.0.7 and RRDI 2.0.6 and on SQL server 2008. We want to move databases to SQL server 2012.
On JAZZ side, all we need to take backup of jts,cm,qm,datawarehouse database, restore those to new server, update teamserver.properties and then restart applications.
However on RRDI side, I am unable to find instructions to migrating databases to new server. What all files i need to update so that contentstore database starts pointing to new server ?
Will appreciate if someone can point me to the guide for migration databases for RRDI.
Regards
Vishnu Kumar
On JAZZ side, all we need to take backup of jts,cm,qm,datawarehouse database, restore those to new server, update teamserver.properties and then restart applications.
However on RRDI side, I am unable to find instructions to migrating databases to new server. What all files i need to update so that contentstore database starts pointing to new server ?
Will appreciate if someone can point me to the guide for migration databases for RRDI.
Regards
Vishnu Kumar
One answer
Hello Vishnu,
after you move the content store to a new server you need to change the connection details in IBM Cognos Configuration.
after you move the content store to a new server you need to change the connection details in IBM Cognos Configuration.
- For Windows, click Start > All Programs > Rational Reporting for Development Intelligence > IBM Cognos > IBM Cognos Configuration.
- Navigate to Data Access > Content Manager > Content Store
- Enter the new connection details to the content store database.
- Save and restart the RRDI profile.
For the data warehouse you can check the procedure described in the following link to manually change the RIDW connection:
Configuring the data source connection for the data warehouse
http://www-01.ibm.com/support/knowledgecenter/SSYMRC_3.0.1/com.ibm.rational.rcpr.help.doc/topics/t_cognos_signon.html
Best Regards,
Francesco Chiossi