Re: [External] : DB2 to Oracle Migration

Hi

Take a look at these 2 options.

https://docs.oracle.com/en/database/oracle/oracle-database/19/drdag/database-gateway-drda-introduction.html#GUID-DBF94092-C4F6-43C0-912C-9DF88448F2F1 https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/db2-for-i-cdc-connector/introduction-to-db2-for-i-cdc-connector.html

Thanks
Ram Cheruvattath

On Mon, Oct 2, 2023 at 2:15 AM Jeff Smith <dmarc-noreply_at_freelists.org> wrote:

>
> Unload to flat files then load back in as external tables or sqlldr, SQL
> Developer will help with that as well.
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of manikandan <pvmanikandan_at_gmail.com>
> *Sent:* Monday, October 2, 2023 12:53 AM
> *To:* Oracle Mailinglist <oracle-l_at_freelists.org>
> *Subject:* [External] : 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