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
chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member
Hello

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
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

Thanks and Regards
Chetan
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 Mar 28 14:31:43 CDT 2024