List:General Discussion« Previous MessageNext Message »
From:Guido Schlenke Date:November 16 2010 7:30am
Subject:Re: Oracle imports into MySQL
View as plain text  
Hi Machiel,

I'm not sure if you like the method I use for Export from Oracle to MySQL 
databases:

You need an ODBC DSN for each, source and destination DB. Then you create an 
empty Access Database with a link to the Oracle Source table.

If the destination MySQL table doesn't yet exists, you can export the linked 
oracle table directly into the existing ODBC-DSN of the MySQL DB.
If (later on) the destination MySQL table exists, you can create an 
Add-Query that inserts selected rows from the Oracle table to the end of the 
MySQL table.

These actions could be placed into macros (Access 'autoexec' for example) 
and in scheduled jobs of your operating system (I hope it's Windows, because 
you didn't say anything about that).

If you don't like the Access built-in Visual Basic language, you can use any 
other programming language that has components to access to ODBC databases 
like Borland/Embarcadero C++Builder/Delphi or Microsoft Visual C++ etc.

Hope this helps.

Guido

"Machiel Richards" <machielr@stripped> schrieb im Newsbeitrag 
news:1289457988.2320.27.camel@machielr-laptop...
> 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
> 



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