Friday, May 27, 2011

Feasible way to convert SQL Server to Oracle Store procedure

Using Oracle SQL Developer, We can convert any 3rd party SQL procedures into Oracle (PL/SQL)

Sample Example (Convert SQL Server procedure into Oracle) as shown below

Step 1; we have the option in Oracle SQL Developer using Migration menu.

From Migration menu, select Translation Scratch Editor

Refer screen shot below:








Step 2; Get SQL Server stored procedure

Copy the stored procedure from SQL SERVER into Scratch Editor window (3rd party SQL window)


Step 3; Translate SQL Server procedure into oracle

Select translate option as shown below



We can convert any other 3rd party sql procedure (like Access SQL to Oracle, Sybase Sql to Oracle and SQL Server T-Sql into Oracle (PL/SQL)).


Step4: Output

The procedure automatically translates from SQL procedure into Oracle (PL/SQL) procedure.






Parallel programming