Is possible to update RequisitePro URL association after RQM data is migrated?
All,
I have RQM 2.0.1 running on RQMServerA. It is integrated with RequsitePro via the ReqWeb service which is set up on the same server RQMServerA. The URL for accessing ReqPro documents from within RQM is http://RQMServerA:11080. I am migrating RQM 2.0.1 data to RQM 3.0.1 which is set up on a different server, RQMServerB (RTC, JTS and CCM 3.0.1 are also installed on RQMServerB along with RQM). I will be taking RQMServerA offline, hence I have also set up the ReqWeb service on RQMServerB. After I migrated the data to RQM v3.0.1, the URL for all of the existing artifacts is still pointing to http://RQMServerA:11080, but I need to change this to http://RQMServerB:11080, since I am also planning to move the ReqWeb service to RQMServerB. I need to update the ReqPro URL for all of my existing artifacts in the migrated DB, so that the URL points to http://RQMServerB:11080. has anyone encountered this scenario? If yes, how can I update the reference/association for all of the existing items in the RQM schema? The DB schema is set up in Oracle 10g. I took a quick look at the tables in the RQM schema, but given their large volume, I am not sure which table(s) contain the reference to the RequisitePro URL.
If it's a simple matter of identifying the relevant tables in the schema and running a SQL update query, I was wondering if someone can point me in the right direction, as it would be a big help.
Thanks,
Kevin