steps to be followed to migrate t-sql code to pl-sql ?

  • Hi All,

    I wanted to convert t-sql code to Pl-sql(oracle 11g).

    Can any body guide what are the steps to be followed to migrate this code and how ?

    And also please suggest some good sites like sql servercentral.com

    to query pl.sql related question, forum etc.

    Regards,

    Ravi 🙂

  • ravi@sql (1/14/2013)


    Hi All,

    I wanted to convert t-sql code to Pl-sql(oracle 11g).

    Can any body guide what are the steps to be followed to migrate this code and how ?

    And also please suggest some good sites like sql servercentral.com

    to query pl.sql related question, forum etc.

    Regards,

    Ravi 🙂

    I dont know of any sites that will do it for you (unlike the VB to C# conversion sites). Mostly because there are so many nuances between the 2 languages. Things I would do in SQL Server I would never attempt in PL-SQL and vice versa. Simple things like TRIM that do things in Oracle that does not happen in SQL Server. Return values, variables, scope, packages... the list goes on.

    The real question is, is it really necessary to move it? The 2 can coexist.

  • It also is dependent on what you are porting to Oracle what needs to be done differently between PL/SQL and T-SQL.

Viewing 3 posts - 1 through 2 (of 2 total)

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