Migrating SQL server Stored procs to Oracle

[Guest_imported]

Is there any utility that can help migrate stored procedures written in SQL server to Oracle 8i, given that the tables/columns are same in both the RDBMS?

 

[foxdev]

In my research into various DBMS utilities, I've encountered some were the tool itself would work for both, but could not automatically change the code from one to the other.

There are substantial differences between PL/SQL and T-SQL, and I'd be surprised if there was an automated conversion tool available. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[Tim1]

Hiya,

I have to say that if there is one, I have not heard about it. I have been part of a team that spend 5 months converting from MS-SQL to Oracle 8i, and all the stored procs basically had to be re-written from scratch to allow for the differences between PL/SQL and T-SQL. However, it does offer you opportunities to sort out any problems and take advantage of the features offered by PL/SQL.

Tim