How to transfer the contents of a table from Oracle to MySQL using PHP?

Question

PHP

Good afternoon, how can I use PHP to transfer the contents of one table (views) in Oracle to another MySQL table
, considering that the set of fields of the receiver table are identical
Found a way when between two mysqls https://gist.github.com/kharysharpe/11275211
but considering that my knowledge of php is not strong, I am at a loss how to do it correctly under oracle

Answer 1

Connect MySQL database to Oracle via dblink and then in oracle:

insert into [email protected]_mysql_db
select * from my_table;

I would first try this, and if it doesn’t work out, you can already try to pervert.

Answer 2

If you cannot do it through PHP, then you can make a dblink in Oracle and write from it in PHP. Another option is to export and import data. You generate inserts and pour into mysql. In my opinion, dblink is the best in this situation.