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@xxxxxxxxx>
Date: Monday, October 2, 2023 at 10:04 AM
To: Bobby Curtis (DBASOLVED) <curtisbl@xxxxxxxxx>
Cc: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx<mailto:curtisbl@xxxxxxxxx>> 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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> on behalf
of manikandan <pvmanikandan@xxxxxxxxx<mailto:pvmanikandan@xxxxxxxxx>>
Date: Monday, October 2, 2023 at 12:54 AM
To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
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