Re: DB2 to Oracle Migration

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 Received on Mon Oct 02 2023 - 13:36:26 CEST