March 7, 2016 at 2:19 pm
Does anyone know of a tool that can convert PL/SQL code to T-SQL? I spent some time on Google, but I would like something reputable.
It doesn't have to be a free tool, just not crazy expensive. I am more concerned with accuracy at this time, since I have several PL/SQL scripts to convert.
Thanks!
The are no problems, only solutions. --John Lennon
March 8, 2016 at 1:35 am
The SQL Server Migration Assistant for Oracle can do that. Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=43689
-- Gianluca Sartori
March 8, 2016 at 5:22 am
i am definitely under the impression that procedures/functions/packages have to be hand edited, as there's no specific set of rules to convert them;
the migration assistant is fine for tables and views, but other objects are a manual process.
Having had to code in both worlds, i often had to make the "same" procedure in both systems, and there's no direct way of converting procedures.
Lowell
March 8, 2016 at 6:56 am
I figured that the tools will not convert everything. I am hoping to get some assistance since I haven't used PL/SQL since Oracle 8i.
Thank you all so much for your input.
The are no problems, only solutions. --John Lennon
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy