conversion of SQL Server 2008 stored procedure to Oracle 10g

Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kccrosser
    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).
    3,830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following