Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS Expand / Collapse
Author
Message
Posted Saturday, November 12, 2011 4:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:26 PM
Points: 87, Visits: 217
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
Posted Saturday, November 12, 2011 5:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 12,899, Visits: 32,113
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
Posted Monday, November 14, 2011 5:54 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1205078
Posted Monday, November 14, 2011 6:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 12,899, Visits: 32,113
PaulB-TheOneAndOnly (11/14/2011)

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

kewl! where can i download that?!


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
Posted Monday, November 14, 2011 6:11 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 6:13 AM
Points: 20,575, Visits: 9,618
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.
Post #1205092
Posted Tuesday, November 15, 2011 7:59 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 18, 2013 6:12 AM
Points: 952, Visits: 552
No, no, no. It's been deprecated
Post #1206019
Posted Tuesday, November 15, 2011 10:11 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:26 PM
Points: 87, Visits: 217
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 !!
Post #1206413
Posted Wednesday, November 16, 2011 4:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 12,899, Visits: 32,113
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
Posted Wednesday, November 16, 2011 12:18 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1207043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse