Home > IT Answers > Oracle > conversion of SQL Server 2008 stored procedure to Oracle 10g
Oracle10gSQLserver2008
5 pts.
 conversion of SQL Server 2008 stored procedure to Oracle 10g
Oracle 10g, SQL Server 2008, SQL stored procedures
Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g

Software/Hardware used:
ASKED: July 2, 2011  7:54 AM
UPDATED: May 15, 2012  3:20 AM
RELATED QUESTIONS
Answer Wiki:
There are lots of differences. For example there is no VARCHAR data type in Oracle, you'll have to use VARCHAR2 instead. Using user defined functions is basically the same. The big difference is that SQL Server using T/SQL and Oracle uses PL/SQL as the programming language. All the code within the procedure will need to be changed from T/SQL to PL/SQL. Kevin Kline has a good out which shows a lot of the differences between the two. use the Oracle Golden Gate First you need a copy of Oracle GoldenGate v11 for SQL Server. You can download it from http://edelivery.oracle.com (Oracle Fusion Middleware → Microsoft Windows x32 → Oracle GoldenGate for Non Oracle Database v11). The serial number of the media pack that you need is V22241-01. you can consult http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html just follow the instructions, and you will have all your database and functions translated to Oracle.
Last Wiki Answer Submitted:  May 15, 2012  3:20 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If you are converting more than one or two stored procedures, you should find and acquire a conversion tool. There are enough syntax differences between T-SQL and PL/SQL that manual conversion is a pain.

Google “t-sql to pl/sql converter” or “t-sql to pl/sql conversion” and you will find lots of links. Any decent converter should automatically convert 90%+ of the existing code.

The good news is that virtually anything coded in T-SQL can be “transliterated” to PL/SQL. The reverse is not true, as there are some advanced structural capabilities of PL/SQL for which there are no T-SQL equivalents (nested procedures/functions and Packages being two major issues).

Kccrosser
 3,830 pts.