Home » Open Source » MySQL » Insert data from Oracle 11g to MYSQL (Linux, Windows)
Insert data from Oracle 11g to MYSQL [message #678139] Tue, 12 November 2019 23:51 Go to next message
chintan.patel
Messages: 159
Registered: July 2008
Location: Ahmedabad
Senior Member
Hi friends,

I would like to insert data from oracle to mysql. I have one view in oracle 11g (on linux OS) and one table in mysql (on Windows OS). I wish to select data from oracle view and insert the same into mysql table. Is there any method to do the same. If yes please guide me so i will do efforts to that direction.

Thank You,
Chintan
Re: Insert data from Oracle 11g to MYSQL [message #678185 is a reply to message #678139] Thu, 14 November 2019 14:13 Go to previous messageGo to next message
BlackSwan
Messages: 26642
Registered: January 2009
Location: SoCal
Senior Member
chintan.patel wrote on Tue, 12 November 2019 21:51
Hi friends,

I would like to insert data from oracle to mysql. I have one view in oracle 11g (on linux OS) and one table in mysql (on Windows OS). I wish to select data from oracle view and insert the same into mysql table. Is there any method to do the same. If yes please guide me so i will do efforts to that direction.

Thank You,
Chintan

Since PERL can inter-operate against both DBs, I would write some PERL that did a SELECT FROM ORACLE into PERL variables & then INSERT INTO MYSQL using the same PERL variables.
Re: Insert data from Oracle 11g to MYSQL [message #678197 is a reply to message #678139] Fri, 15 November 2019 13:24 Go to previous message
John Watson
Messages: 8077
Registered: January 2010
Location: Global Village
Senior Member
You probably need to look at the Database Gateway for ODBC (DG4ODBC). To your software, it is just a database link like any other.
Previous Topic: How to reduce time for below SQL.
Goto Forum:
  


Current Time: Mon Dec 09 20:48:48 CST 2019