Re: DB2 to Oracle Migration

Thanks Bobby.

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

> Yes, you need to use the table as a source. I did this for a customer
> going from Tandum to AWS with no problem.
>
>
>
> -- Bobby
>
>
>
> --Sent from Gmail Account
>
>
>
>
>
> *From: *manikandan <pvmanikandan_at_gmail.com>
> *Date: *Monday, October 2, 2023 at 10:04 AM
> *To: *Bobby Curtis (DBASOLVED) <curtisbl_at_gmail.com>
> *Cc: *Oracle Mailinglist <oracle-l_at_freelists.org>
> *Subject: *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