Click to See Complete Forum and Search --> : From MySql to Oracle


rpcarnell
03-19-2009, 05:13 AM
I am updating a webpage that uses an Oracle database. Thing is I am using a Mysql Database.

How difficult is it to export the concents of a Mysql DB to an Oracle one?

Seems to me like using the SQL file should do the trick, since SQL is SQL in all databases.

_____________________________
http://www.redacron.com

Kuriyama
03-19-2009, 09:45 AM
I know that the MySQL administrator tools (if you installed them) will automatically generate export script for you to run in oracle. I also believe that oracle (if you aren't using the free version) will allow you to run import jobs that will connect to other databases.

In other words. . . very easy.