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

steps to be followed to migrate t-sql code to pl-sql ? Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 10:21 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:02 AM
Points: 93, Visits: 195

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 :)
Post #1407027
Posted Tuesday, January 15, 2013 11:51 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 16, 2013 8:28 AM
Points: 249, Visits: 460
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.
Post #1407412
Posted Tuesday, January 15, 2013 1:00 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 12:34 PM
Points: 23,275, Visits: 31,992
It also is dependent on what you are porting to Oracle what needs to be done differently between PL/SQL and T-SQL.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1407443
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse