How do I migrate data from an Oracle database to a MySQL database?

There are many data integration tools available. It all depends on the scale. How many rows are you moving?For ad-hoc jobs you may want to look at https://github.com/data-buddy/Databuddy/blob/master/README.mdIt has a GUI and CLI (command line) components.You use Databuddy GUI to define data copy vector and Databuddy CLI will do actual data transfer.Low touch configuration lets you define SQL for Oracle data that you want to copy and target MySQL table name and save it a s a session.Example: Define copy vector. If you are moving only subset of table data or query results you will need ORA11G_QueryFile source template: Here's your session created and ready to be configured: When you set SQL query file and target table click "Run" button. It opens Windows CLI window and executes data copy.(Image is for SQL Server extract to CSV, but it gives the idea) You are done!

You can easily migrate between Oracle and MySQL using SQLDeveloper.  I've successfully done this in a test environment. If the data set isn't too big, you can create the equivalent structure in MySQL and dump out the data from Oracle into csv format to load it into MySQL eventually.

Heres ahttps://developer.appcelerator.com/question/126758/couchdb-mobile