OraFAQ Forum: Client Tools » how to convert SQL server stored procedures to Oracle 11g

Home » SQL & PL/SQL » Client Tools » how to convert SQL server stored procedures to Oracle 11g (Oracle 11g)

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

how to convert SQL server stored procedures to Oracle 11g [message #594788]

Tue, 03 September 2013 03:02

ramya_162
Messages: 107
Registered: August 2013
Location: Banglore

Senior Member

Hi Experts,

In SQL server 30 stored procedures are there how to convert all the stored procedure
from SQL server to Oracle 11g.

Please help me,

Thanks.

Report message to a moderator

Re: how to convert SQL server stored procedures to Oracle 11g [message #594789 is a reply to message #594788]

Tue, 03 September 2013 03:33

Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you want to convert the code, there is no problem, many tools can do it.
But migrating code from SQL Server to Oracle does not just mean convert code, it means rewrite it as the transactional models are different.

Regards
Michel

Report message to a moderator

Re: how to convert SQL server stored procedures to Oracle 11g [message #594795 is a reply to message #594789]

Tue, 03 September 2013 04:42

ramya_162
Messages: 107
Registered: August 2013
Location: Banglore

Senior Member

Hi,

I want to convert the SQL server code to Oracle code with oracle syntax
with the same functionality.

Please name one tool which good and easiest.

Thanks.

Report message to a moderator

Re: how to convert SQL server stored procedures to Oracle 11g [message #594798 is a reply to message #594795]

Tue, 03 September 2013 04:46

Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please just Google.

Regards
Michel

Report message to a moderator

Re: how to convert SQL server stored procedures to Oracle 11g [message #594856 is a reply to message #594788]

Tue, 03 September 2013 09:29

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

Oracle SQL Developer's migration projects will be able to help you a bit. Really the nature of the problem comes down to what your stored procs are doing. Many T-SQL procs are just queries with the data coming back.

To get that working in Oracle will require you to rewrite them such to use explicit cursors and change the procedure arguments to include an out params or return values.

However, that's changed a bit for Oracle Database 12c - for the better.

Report message to a moderator

Previous Topic:	SQLPLUS for Oracle 11 not rolling back
Next Topic:	display windows on OracleSQL Developer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 08 03:23:20 CDT 2022