This content has been marked as final. Show 4 replies
You could use the 'Translation Scratch Editor' in SQL*Developer to translate SQL*Server statements to Oracle.
SQL*Developer is free and can be downloaded from here -
Once installed start it up, then go to 'Tools' - 'Migration' - 'Translation Scratch Editor'
I did run the statement you have posted here through it but it gave errors so looks like there may be a problem with the syntx in any case.
Does this query run as it is in SQL*Server ?
Edited by: mkirtley on Jan 5, 2012 12:45 PM
yes it runs ok. i will hav a look at that tool thanks!
I am using this tool in Oracle SQL Developer, the Scratch Editor, and I have it set to the correct translation (M'soft SQL Server to PL/SQL) and it's skipping almost every line of code. I tried to play around with different translations in the editor with no luck (just to see what it did).
I really do NOT recommend this tool, it's useless. Basically if you can't figure it out, get a book on the language or ask a colleague to translate for you if you have enough pride to do so.
It is possible that you are running into a bug in the translation scratch editor. Make sure that you are using the latest version of SQL developer I.e. 3107. If possible post your query that you are trying to convert. We can try to determine the root cause. I am sure you found SQL developer useful for many other tasks. You can also try putting the SQL in a file and convert using the command line API.