Re: Oracle imports into MySQL

2010-11-15 Thread Guido Schlenke
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

Re: Oracle imports into MySQL

2010-11-12 Thread Johan De Meersman
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

Oracle imports into MySQL

2010-11-10 Thread Machiel Richards
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