How way to copy oracle data to remote mysql server

Asked Apr 11 '14 at 10:17

Active Apr 11 '14 at 10:17

Viewed 351 times

I need to copy oracle table data into remote mysql server.

I tried something and the list are below

The oracle data can export as .sql file and then remove the ddl statement and make insert according to mysql syntax, this is not feasible since the process should be automated

2. Making heterogeneous dblink, making dblink is done,dblink ping also successful but got error in select statement,ORA-28513: internal error in heterogeneous remote agent ORA-02063: preceding line from MYSQLLINK and heard that data loading via dblink is very slow

Or i should look into any ETL tool like penthao kettle

Any suggestion will be much appreciated

asked Apr 11 '14 at 10:17

jasim

Check this: http://stackoverflow.com/questions/7822954/import-data-to-mysql-from-oracle/22936746#22936746 and i think SQLyog has an option to automate the process – Sathish D Apr 11 '14 at 10:25
that is sqlyog ultimate edition – jasim Apr 11 '14 at 11:37
Most of the tools which does this will be commercial versions. – Sathish D Apr 11 '14 at 11:45

How way to copy oracle data to remote mysql server

0 Answers0