Re: DB2 to Oracle Migration
Date: Mon, 2 Oct 2023 15:18:55 +0000
Message-ID: <DM6PR12MB276226E7BAC50341F06D6894A4C5A_at_DM6PR12MB2762.namprd12.prod.outlook.com>
Yes, you need to use the table as a source. I did this for a customer going from Tandum to AWS with no problem.
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,
On Mon, Oct 2, 2023 at 6:36 AM Bobby Curtis (DBASOLVED) <curtisbl_at_gmail.com<mailto: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.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of manikandan <pvmanikandan_at_gmail.com<mailto:pvmanikandan_at_gmail.com>>
Date: Monday, October 2, 2023 at 12:54 AM
To: Oracle Mailinglist <oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>>
Subject: DB2 to Oracle Migration
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,
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.
Mani
Hi,
Mani
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 02 2023 - 17:18:55 CEST