OraFAQ Forum: MySQL » Insert data from Oracle 11g to MYSQL

Home » Open Source » MySQL » Insert data from Oracle 11g to MYSQL (Linux, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert data from Oracle 11g to MYSQL [message #678139]

Tue, 12 November 2019 23:51

chintan.patel
Messages: 162
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

Report message to a moderator

Re: Insert data from Oracle 11g to MYSQL [message #678185 is a reply to message #678139]

Thu, 14 November 2019 14:13

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Insert data from Oracle 11g to MYSQL [message #678197 is a reply to message #678139]

Fri, 15 November 2019 13:24

John Watson
Messages: 8960
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.

Report message to a moderator

Previous Topic:

How to reduce time for below SQL.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 07:03:05 CST 2024