I'm not sure if you like the method I use for Export from Oracle to MySQL
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
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.
"Machiel Richards" <machielr@stripped> schrieb im Newsbeitrag
> 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
> 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.