Re: DB2 to Oracle Migration

Thanks for the information Bobby. My concern is whether GoldenGate is capable of load static data from TB size table from DB2 to Oracle using mentioned Initial Load.

Thanks,
Mani

On Mon, Oct 2, 2023 at 6:36 AM Bobby Curtis (DBASOLVED) <curtisbl_at_gmail.com> wrote:

> Oracle GoldenGate can do the migration for both the DDL and the DML. Your
> approach of pulling the DDL with SQLDev would work for Oracle but not DB2.
> In short, you have half the solution by pulling the DDL and importing it
> into Oracle. To get the DML/static data out of DB2, you can still use a
> file-based initial load with GoldenGate – similar to the approach here ->
> https://www.dbasolved.com/2018/05/loading-tables-with-oracle-goldengate-and-rest-apis/.
> With DB2, extracting data has been eased by the fact that GoldenGate for
> DB2 is not off-box and uses remote capture (extract); enabling simpler
> writing to EXTFILE.
>
>
>
> Hope this helps.
>
>
>
> -- Bobby
>
>
>
> --Sent from Gmail Account
>
>
>
>
>
> *From: *oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of manikandan <pvmanikandan_at_gmail.com>
> *Date: *Monday, October 2, 2023 at 12:54 AM
> *To: *Oracle Mailinglist <oracle-l_at_freelists.org>
> *Subject: *DB2 to Oracle Migration
>
> Hi,
>
>
>
> Customer has a requirement to migrate their OnPrem DB2 Database to OnPrem
> Oracle (19c).
>
> DB2 database details :- Relational database with 5600 tables across 10
> schema ( 600 tables are system tables). Size is 25TB.
>
> I believe we can extract the schema/table metadata using say SQL Developer
> and create schema and empty tables in Oracle.
>
> It seems Initial load using Golden Gate is not a viable solution in this
> case.
>
> I am looking for a solution to do an Initial load of data to Oracle.
> Please suggest.
>
>
>
> Thanks,
>
> Mani
>
>
>

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