CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

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

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

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

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

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

  • 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 !!:-)

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

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

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

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