Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: migrating data from mysql to oracle.

Re: migrating data from mysql to oracle.

From: Ronald Rood <devnull_at_ronr.nl>
Date: Fri, 3 Mar 2006 10:59:49 +0100
Message-ID: <0001HW.C02DD225000881E4F0284550@news.individual.net>


On Fri, 3 Mar 2006 08:29:14 +0100, JAI via DBMonster.com wrote (in article <5cb0e62d1248c_at_uwe>):

> Can anyone tell me how to migrate tables from mysql to oracle ? I have done
> it using the oracle migration tool.Is it possible thru SQldump ?

If you are able to create some kind of ascii file per table you can easily read them into oracle using sqlloader or external table. You could also try HS (Heterogenous services) to connect from the oracle database directly to the mysql database and use a databaselink to pump it all over.

--
With kind regards / met vriendelijke groeten,
Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle
Received on Fri Mar 03 2006 - 03:59:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US