Re: GoldenGate Oracle to MSSQL Server - Initial Table Create

Martin,

GoldenGate will not create the actual tables in the SQL Server database. Heterogenous DDL support is not available in GG. You will have to move the tables manually. I’ve done this in the past with POCs, but cannot remember exactly how I got the DDL over.

Thanks

Bobby

> On Mar 29, 2022, at 10:26 AM, Martin Klier - Performing Databases GmbH <martin.klier_at_performing-db.com> wrote:
>
> Hi listers,
>
> currently I try to build a "simple" one-way GoldenGate 21c replication of a whole, self-contained Oracle-schema to a database on MS SQL Server. So far, I think I got the idea how to build the instantiation- and replication EXTRACTs and REPLICATs, and I can start them w/o errors and all.
>
> BUT: How do I get GG to CREATE the actual tables in the target database? All I get during instantiation is
>
> EXTRACT:
> INFO OGG-00993 Oracle GoldenGate Capture for Oracle, initex.prm: Extract group EXTRACT INITEX started.
> INFO OGG-02911 Oracle GoldenGate Capture for Oracle, initex.prm: Processing table MYSCHEMA.MYTABLE.
> WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, initex.prm: Extract task INITRP abended : Initial data load error reported by REPLICAT.
> ERROR OGG-01203 Oracle GoldenGate Capture for Oracle, initex.prm: Extract abending.
>
> REPLICAT:
> WARNING OGG-00869 Oracle GoldenGate Delivery for SQL Server: Could not retrieve definition for table dbo.MYTABLE.
> ERROR OGG-00199 Oracle GoldenGate Delivery for SQL Server: Table dbo.MYTABLE does not exist in target database.
> ERROR OGG-01668 Oracle GoldenGate Delivery for SQL Server: PROCESS ABENDING.
>
> That, in fact, is true, but how do I get them there? I can't honestly extract, translate and create thousands of tables manually to SQL Server...
>
> Thank you for your ideas!
>
> --
> Martin Klier // Performing Databases GmbH
> Managing Partner // Senior DB Consultant
> Oracle ACE Director
>
> martin.klier_at_performing-db.com // https://www.performing-databases.com
>
>

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