Re: Need Documentation for RDBMS Migration to Oracle

Hi Asad,

Oracle SQL Developer can convert schema definitions for you, and even move data. Check this doc:

https://docs.oracle.com/en/database/oracle/sql-developer/19.4/rptug/migrating-third-party-databases.html

Best luck,
Albert Balbekov

On Mon, Nov 7, 2022 at 5:40 AM Asad <asad.hasan2004_at_gmail.com> wrote:

> Thanks for your reply. I still have the details of how big is database but
> it would be on exdata platform on the target side may be you can provide me
> the basic steps i am getting confused how the structure of tables get
> converted between db2 and oracle db ?
>
> On Mon, 7 Nov 2022, 18:57 Mladen Gogala, <gogala.mladen_at_gmail.com> wrote:
>
>> On Mon, 2022-11-07 at 13:16 +0530, Asad wrote:
>>
>> Hi All ,
>>
>> Please provide document for migration DB2 RDBMS to oracle rdbms
>> , I think GoldenGate in an option to migrate from DB2 to Oracle ?
>>
>>
>> Well, it depends how do you want to do the migration. Another option
>> would be SQL*Net Gateway for DB2. There are minor detail that I need, in
>> order to suggest something:
>>
>> - How much data is there to migrate?
>> - What's the network throughput?
>> - How fast can Oracle RDBMS write? What kind of disks is used for
>> both DB2 and Oracle?
>> - What are the financial constraints? Neither GoldenGate nor DB2
>> Gateway are free.
>>
>> You will need a project plan and a lot of testing.
>> Regards
>>
> --
>>
>> Mladen Gogala
>> Database Consultant
>> https://dbwhisperer.wordpress.com
>>
>>

--
http://www.freelists.org/webpage/oracle-l