Hi,
Is there a Free tool to convert MySql-5.0 SQL to Oracle-10g SQL?
thanx in advance,,,
views:
155answers:
3
+1
A:
I have used SQLFairy in the past, however, I think it has not been updated in some time.
Could be worth a try still. http://sqlfairy.sourceforge.net/
A lot of it depends on how closely your code meets ansi 92
Irwin M. Fletcher
2009-12-24 14:18:48
Thanks, but I am not familiar with perl, so I couldn't run/use it
Moro
2009-12-25 16:25:03
+2
A:
You can try Oracle's SQL Developer Migration (which is a free product). The docs say it will help migrate Microsoft Access, Microsoft SQL Server, MySQL and Sybase to Oracle:
http://www.oracle.com/technology/tech/migration//workbench/index%5Fsqldev%5Fomwb.html
Dougman
2009-12-24 15:58:33
I think it requires to have an Oracle Database server, but this is not my case. I want to convert the SQL code only.
Moro
2009-12-24 20:04:45
In theory any ansi compliant sql will run on Oracle. Do you mean sql inserts so you can move your data or are you trying to write any arbitrary SQL and have it run on both MySQL and Oracle?
Dougman
2009-12-24 21:48:59
It has translators from Microsoft, Access, DB2, Sybase SQl to Oracle SQL ... but I didn't find one for MySql in it ... so, I did the translation manually and used it for validation. Thanks in any way.
Moro
2009-12-25 16:25:47
A:
SQLFairy will do a better job of converting the schema - but it will not convert data. Oracle's SQL Developer Migration tool will convert both - I have used both of them - first the schema - then the data.
Philip Schlump
2009-12-25 15:20:10