SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

migration steps for converting t-sql code to pl/sql

2988654Sep 9 2015 — edited Sep 14 2015

Hello,

I am working on a sql server-to-oracle migration project with a team that isn't very experienced with Oracle. My role is just a developer/analyst but there are architects and DBAs who are also new to Oracle. What they have suggested is that we manually take each t-sql procedure and convert it to pl/sql in SQL Developer Scratch Editor and then test it. We have 1000+ procs so this approach does not seem logical to me personally. Wouldn't there be a way where DBAs/Architects can convert all procs to pl/sql at once and compare data on their own and then involve us developers/analysts only when there are discrepancies?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2015

Added on Sep 9 2015

35 comments

5,736 views