It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×10,943
×7,443
×1,272
×784

question asked: Jul 31, 1:34 a.m.
question was seen: 123 times
last updated: Jul 31, 10:57 a.m.

Related questions

Feasibility of transferring SQL data to an Oracle database through an external software solution.

0
Venkatesh Bhat (29●1●4) | asked Jul 31, 1:34 a.m.
We are in the process of migrating the ELM 7.0.2 applications database from SQL to Oracle as part of the ELM 7.0.3 upgrade initiative. The database sizes for CCM1 and CCM2 are approximately 4TB and 1TB, respectively, with an estimated migration duration of 4 to 5 days. However, our organization has a policy that restricts downtime to a maximum of 2 days. After discussions with the DBA team, we have determined that we can utilize "Golden Gate" to facilitate the migration from SQL to Oracle, allowing us to capture the delta changes during the transition. The DBA team has also provided a URL that outlines the step-by-step procedure for this process.


The DBA team seeks confirmation from IBM development regarding the possibility of employing external tools such as "Golden Gate" for the migration and configuring the applications to minimize downtime. Please reach out if any clarifications are needed.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Ralph Schoon (63.3k●3●36●46) | answered Jul 31, 2:27 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Jul 31, 2:36 a.m.

This is a user forum and not IBM ELM support. There is no way to get any confirmation for your approach in this forum.

However, for all I know, you approach is not supported and likely not going to be successful.

The only documented way to migrate between databases can be found in the product help and involves an export of the data and an import of the data. https://www.ibm.com/docs/en/engineering-lifecycle-management-suite/lifecycle-management/7.0.3?topic=database-migrating-databases

There has been some effort to make the process of exporting and importing faster and more efficient in the recent releases. However, obviously, it will take the time it will take to do the migration.    

If you need more information on this, I would suggest to get in contact with support. There are possibilities to arrange test migrations and having support available standby in case of issues.

Comments
Daniel Moul commented Jul 31, 10:57 a.m.
FORUM MODERATOR / JAZZ DEVELOPER

Adding to Ralph's answer: there are repotools commands available for this (exportConcurrent, importConcurrent, compare). The exception is the data warehouse, for which standard database migration tooling can be used. As he wrote: see the ELM documentation and if you need more information, ask IBM Support.

Your answer

Register or 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.