Re: GoldenGate Oracle to MSSQL Server - Initial Table Create

I'ved tested the SQL Server Migration Assistant for Oracle with the HR schema.

https://www.youtube.com/watch?v=zNTF1ncr45g

Hemant K Chitale

On Tue, Mar 29, 2022 at 10:26 PM 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