List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 12 2010 10:31am
Subject:Re: Oracle imports into MySQL
View as plain text  
My quick suggestion for such a process would be to use SQL*NET formatting
commands to create a well-formed CSV file, which you then import into MySQL
using LOAD DATA INFILE.

I'm not aware of any Oracle-specific import tools in MySQL. If anything,
after the merger I would rather expect something that goes the other way
round :-)


On Thu, Nov 11, 2010 at 7:46 AM, Machiel Richards <machielr@stripped>wrote:

> Good day all
>
>    I am hoping that someone has got some more answers for me on the
> topic as most of the websites which have not been very useful.
>
>    All websites I have found thus far reffers to software that either
> needs to be bought or otherwise need to be run manually.
>
>
>     One of our clients are currently running MySQL for their web based
> systems, however all other systems are running oracle.
>
>    There is a current "data load" process from oracle that generates a
> dump file of specific data, goes through a convertion process, gets
> imported into a mysql runnign on VM to test import, then gets pushed to
> MySQL production.
>
>    This process was put in place quite some time ago by developers.
>
>     At some stage I read something about this process not being
> required from MySQL 5 onwards and data imports from oracle is less
> troublesome.
>
>
>      The import process needs to run every 30 minutes and the current
> process is too troublesome.
>
>        We are busy plannign a hardware migration for the systems and
> are also looking at improving these processes.
>
>        Does anybody have experience with this to perhaps provide me
> with some info on how we can improve this import process?
>
>        Any assistance will be appreciated.
>
> Regards
> Machiel
>



-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Oracle imports into MySQLMachiel Richards11 Nov
  • Re: Oracle imports into MySQLJohan De Meersman12 Nov
  • Re: Oracle imports into MySQLGuido Schlenke16 Nov