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

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

Questions
Tags
Users
Badges
Venkatesh Bhat
(29●7●5●6) Jul 31 '24, 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.

0 votes

1 answer
579 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) edited
Jul 31 '24, 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.

0 votes

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

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 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
× 7,512
× 1,342

Question asked: Jul 31 '24, 1:34 a.m.

Question was seen: 579 times

Last updated: Jul 31 '24, 10:57 a.m.

Confirmation Cancel Confirm