Re: Need Documentation for RDBMS Migration to Oracle

From: Asad <asad.hasan2004_at_gmail.com>
Date: Mon, 7 Nov 2022 19:10:27 +0530
Message-ID: <CAG3LsKFM1y+CByPYMemeR6orOcgZ+2gqd+u=Hb9JeBXmshV3Ew_at_mail.gmail.com>



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
Received on Mon Nov 07 2022 - 14:40:27 CET

Original text of this message