Re: DB2 to Oracle Migration

Thanks for the links Jeremiah.
But in this case, target database is also an OnPrem database. Will AWS support load of huge data sets say billions of rows with large number of columns?

Thanks,
Mani

On Mon, Oct 2, 2023 at 12:01 AM Jeremiah Wilton <jcwilton93_at_earlham.edu> wrote:

> AWS Database Migration Service supports Db2 to Oracle via AWS.
>
> https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.html
>
> https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.html
>
> Thanks
> Jeremiah
>
> On Oct 1, 2023, at 9:53 PM, manikandan <pvmanikandan_at_gmail.com> wrote:
>
> 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
>
>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
> =
>
>

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