OraFAQ Forum: MySQL » oracle dump to Mysql database.

Home » Open Source » MySQL » oracle dump to Mysql database.

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

oracle dump to Mysql database. [message #233009]

Tue, 24 April 2007 06:57

koff10
Messages: 58
Registered: December 2006
Location: france

Member

Hi All,
I'm trying to export oracle data and import it to Mysql database.
How can I perform it ?

Report message to a moderator

Re: oracle dump to Mysql database. [message #233120 is a reply to message #233009]

Tue, 24 April 2007 16:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, you can not. Oracle Export utility produces a file which can be read only by Oracle Import utility. You'll have to take another approach (perhaps even INSERT statements).

Report message to a moderator

Re: oracle dump to Mysql database. [message #233182 is a reply to message #233009]

Wed, 25 April 2007 02:36

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Use SQL Server DTS (data tran. service)

Report message to a moderator

Re: oracle dump to Mysql database. [message #238713 is a reply to message #233182]

Sat, 19 May 2007 11:32

convertin
Messages: 14
Registered: May 2007

Junior Member

Try OraDump-to-MySQL conversion tool by Intelligent Converters:

http://www.convert-in.com/ord2sql.htm

Report message to a moderator

Previous Topic:	Migrate MySQL Table to Oracle Materialized View
Next Topic:	OCA 6.0.5.3x required to connect mysql through froms6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 06 23:14:02 CDT 2025