CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA...

CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

Rate Topic

Display Mode

Topic Options

Author

Message

shubham.saxena67

Posted Saturday, November 12, 2011 4:18 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:09 AM
Points: 78, Visits: 197

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!!

Post #1204586

Lowell

Posted Saturday, November 12, 2011 5:38 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:11 PM
Points: 11,638, Visits: 27,710

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1204612

PaulB-TheOneAndOnly

Posted Monday, November 14, 2011 5:54 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 2,984, Visits: 4,403

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 Smile

_____________________________________
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.

Post #1205078

Lowell

Posted Monday, November 14, 2011 6:09 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:11 PM
Points: 11,638, Visits: 27,710

PaulB-TheOneAndOnly (11/14/2011)

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

kewl! where can i download that?! BigGrin

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1205088

Ninja's_RGR'us

Posted Monday, November 14, 2011 6:11 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:43 PM
Points: 21,357, Visits: 9,536

Lowell (11/14/2011)

PaulB-TheOneAndOnly (11/14/2011)

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

kewl! where can i download that?! BigGrin

It's BO.

Post #1205092

Stephen_W_Dodd

Posted Tuesday, November 15, 2011 7:59 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 6:22 AM
Points: 803, Visits: 538

No, no, no. It's been deprecated Hehe

Post #1206019

shubham.saxena67

Posted Tuesday, November 15, 2011 10:11 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:09 AM
Points: 78, Visits: 197

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 !! Smile

Post #1206413

Lowell

Posted Wednesday, November 16, 2011 4:10 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:11 PM
Points: 11,638, Visits: 27,710

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1206530

PaulB-TheOneAndOnly

Posted Wednesday, November 16, 2011 12:18 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 2,984, Visits: 4,403

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 Smile

Post #1207043

« Prev Topic | Next Topic »

Permissions