CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

Question

CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

shubham.saxena67

Default port

Points: 1490
More actions
November 12, 2011 at 4:18 am

#262653

Dear Friends,
I want to convert stored procedure that containg Loops ,Table valued
functions,Scalar Function written in Oracle to SQL Procedure and functions
Is there any tool ?
Thanks!!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

shubham.saxena67 (11/12/2011)
Dear Friends,
I want to convert stored procedure that containing Loops ,Table valued
functions,Scalar Function written in Oracle to SQL Procedure and functions
Is there any tool ?
Thanks!!

no, there's no set of specific rules that could be applied to convert a proc; only basic insert/update/select/delete can be converted by applying specific rules or find/replace.

you'll have to rewrite the proc for SQL, and vice versa.

if you post it, and it's not to huge, one of our volunteers might take a stab at it, or at least give you a push in the right direction.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 2

shubham.saxena67 (11/12/2011)
I want to convert stored procedure that containg Loops ,Table valued
functions,Scalar Function written in Oracle to SQL Procedure and functions
Is there any tool ?

I'm in agreement with Lowell. In my experience - after doing conversions in both directions, the only way is to rewrite the code from scratch. Read the source code, Understand what it does, Write it on the target language.

About tools... yes!... Brain 1.0 has been very useful 🙂

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Lowell SSC Guru Points: 323518 More actions · Answer 3

PaulB-TheOneAndOnly (11/14/2011)
About tools... yes!... Brain 1.0 has been very useful 🙂

kewl! where can i download that?! 😀

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Lowell (11/14/2011)
PaulB-TheOneAndOnly (11/14/2011)
About tools... yes!... Brain 1.0 has been very useful 🙂
kewl! where can i download that?! 😀

It's BO.

Stephen_W_Dodd SSCommitted Points: 1648 More actions · Answer 5

Stephen_W_Dodd

SSCommitted

Points: 1648

November 15, 2011 at 7:59 am

#1407912

No, no, no. It's been deprecated :hehe:

shubham.saxena67 Default port Points: 1490 More actions · Answer 6

Dear All Friends,

I have found a tool names "SQL SERVER MIGRATION ASSITENCE FOR ORACLE" that completely resolved my problem..

Thanks 4 sharing my problem !!:-)

Lowell SSC Guru Points: 323518 More actions · Answer 7

it's a nice tool, migrates schema and data, but leaves you with the list of items that will need to be converted manually...packages, procedures and functions.

glad to hear you are most of the way there!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 8

shubham.saxena67 (11/15/2011)
I have found a tool names "SQL SERVER MIGRATION ASSITENCE FOR ORACLE" that completely resolved my problem.

Once again I'm in agreement with Lowell - SSMA is a fantastic tool for DATA migration but reading your post that was not your real problem 🙂

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.