shubham.saxena67 (11/12/2011)
I want to convert stored procedure that containg Loops ,Table valuedfunctions,Scalar Function written in Oracle to SQL Procedure and functions
Is there any tool ?
I'm in agreement with Lowell. In my experience - after doing conversions in both directions, the only way is to rewrite the code from scratch. Read the source code, Understand what it does, Write it on the target language.
About tools... yes!... Brain 1.0 has been very useful 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.