Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert MS SQL Server 2008 Stored Procedures to Oracle 11g SPs?

user12240205Jun 29 2012 — edited Mar 11 2016

We have a MS SQL Server 2008 application. We want to migrate it to Oracle 11g.

What is the Oracle recommended method for
(1.) Data migration (Tables, triggers, sequences, views etc.)
(2.) Stored Procedure migration.

What is the recommended tool or method pls??

We have 100s of MS Sql Server stored procedures. So, need a tool or method. We can't re-write all of them from scratch.

This post has been answered by orcldeveloper-Oracle on Jul 4 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2012

Added on Jun 29 2012

#database-and-application-migrations

7 comments

17,851 views