Home » Server Options » Replication » create DDL scripts from SQL server to Oracle (SQL Server 2008, Oracle 11g R2 on linux)
create DDL scripts from SQL server to Oracle [message #617959] Sat, 05 July 2014 08:41
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member

We are trying to replicate database from SQL Server 2008 to Oracle 11g R2 database (on linux) using Golden Gate Software 11g

Before we do 'Initial load' we want to create the corresponding table structure and related objects in the Oracle database

As there is variance in the data types (sql servers v/s Oracle) is there any way to create the object script in oracle for corresponding objects in sql server (say 'create table ..' etc)?

I tried following 'OMWB' but it is producing errors

Thanks and Regards
Previous Topic: Getting errors while using mixed versions of Golden Gate Software
Next Topic: Oracle data type mapping for Replication
Goto Forum:

Current Time: Thu Jan 21 12:55:11 CST 2021