Oracle imports into MySQL

--=-q36qGX6PHvb5Wmxn9Sc1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

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

--=-q36qGX6PHvb5Wmxn9Sc1--

Re: Oracle imports into MySQL

--001636c5a7a59475770494d896ac
Content-Type: text/plain; charset=ISO-8859-1

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 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

--001636c5a7a59475770494d896ac--

Re: Oracle imports into MySQL

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" 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
>




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org