OraFAQ Forum: Replication » create DDL scripts from SQL server to Oracle

Home » Server Options » Replication » create DDL scripts from SQL server to Oracle (SQL Server 2008, Oracle 11g R2 on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 17:13:05 CDT 2026