2 Replies Latest reply on Jan 31, 2019 5:53 PM by thatJeffSmith-Oracle

    Translation of Stored Procedures.

    Jammin
    Jammin Jan 31, 2019 5:00 PM

      Hi Folks,

      I need to convert MS-SQLServer stored procedure to Oracle stored procedure

      and I need to tuning them for best performance ever.

      What is the best way ?

       

      Best regards and thanks a lot in advance.

       

      Gianni

      • 66 Views
      • Tags:
        • 1. Re: Translation of Stored Procedures.
          EdStevens
          EdStevens Jan 31, 2019 5:32 PM (in response to Jammin)

          a9f5ff06-c809-491a-86c6-c97e353f100e wrote:

           

          Hi Folks,

          I need to convert MS-SQLServer stored procedure to Oracle stored procedure

          and I need to tuning them for best performance ever.

          What is the best way ?

           

          Best regards and thanks a lot in advance.

           

          Gianni

          This is not as easy as you seem to think.  It's not simply a matter of translating syntax.  MSSQL and Oracle are fundamentally and architecturally different.  This has far reaching implications for any conversion/translation project.  The only way to really do it - especially if 'best performance ever' is a goal, is to re-architect the system and re-write code from scratch, with that re-writing being done by someone who is fluent in oracle.

          • 2. Re: Translation of Stored Procedures.
            thatJeffSmith-Oracle
            thatJeffSmith-Oracle Jan 31, 2019 5:53 PM (in response to Jammin)

            use the existing migration features in SQL Developer

             

            then get ready to do lots and lots of testing and probably write as much as 20-50% PL/SQL on your own where our translators left off. Some customers get as high as 90% of their code translated w/o much work.

             

            Ed's not wrong - if you want to do it 'right' - sometimes changing everything about how your application works with the database is required.