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: steph <stephan0h_at_gmx.net>
Date: 3 Mar 2006 00:05:49 -0800
Message-ID: <1141373149.839198.120930@z34g2000cwc.googlegroups.com>


I have done this once by setting up a HSODBC-connection to the mysql database. After this is setup importing data is reduced to insert-into-select-from. The drawback is probably that it's a bit tricky to set it up, and there are problems with some datatypes. Here's how:
http://www.idevelopment.info/data/Oracle/DBA_tips/Heterogeneous_Services/HETERO_2.shtml

stephan Received on Fri Mar 03 2006 - 02:05:49 CST

Original text of this message

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