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

risk of migrating from sql to oracle in CLM 2012

We are planning to migrated the data from MS SQL db to Oracle db. I heard there is a risk involved in migrating the data from one db vendor to another. did anybody done it successfully or anybody had problems? thk, Natalia

0 votes



One answer

Permanent link
Hi Natalia,

RQM supports database migration from one db vendor to another using repotools -export and -import. I'm not sure what version of RQM you are using but here is a link to instructions on migration: RQM 3.0, RQM 4.0.
Although the instructions are migrating from Derby, its the same process for any db.

It sounds like you are keeping the same RQM instance. If this is the case then you should no other problems.

However, if you are trying to migrate to a different RQM instance also, you will run into issues with the public URI. Every artifact in the database has a reference to the public URI of the original RQM instance. The solution would be to upgrade to RQM 4.0 so that you can perform a server rename, which changes the references of all database artifacts to point to the new RQM instance instead.

1 vote

Your answer

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.

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
× 267
× 119
× 37

Question asked: Mar 01 '13, 1:20 p.m.

Question was seen: 6,624 times

Last updated: Mar 05 '13, 2:45 p.m.

Confirmation Cancel Confirm