Another migration question: stored procedures from MSSQL to ORACLE

[lydiattc]

Hi,

I have more than 50 stored procedures that need to export to Oracle from SQL. I noticed the difference in syntax between MSSQL and Oracle. Is there a way to export stored procedures from MSSQL to ORacle without creating them again in Oracle?

Thanks,
Lydia

 

[Turkbear]

Hi,
Check out the Oracle Migration Workbench

http://otn.oracle.com/tech/migration/workbench/content.html

- If that cannot do it, then it probably cannot be done without much rewriting..SqlServer's syntax is different for many things, although Oracle 9.2's sql is more standard than it used to be..
( Youmay need to register at otn first, do so, it is very handy and free)