data from oracle to mysql?

[Anon]

how can i get the data from my oracle database into mysql database? i can think of one dirty way, which is to save oracle data as text files, then import them through myodbc, or through load file. is there a better more direct way?

thanks!

[Anon]

You're probably stuck. Databases don't really play nice with each other.

I've had some success in creating select statements that build other SQL statements then saving the output into a file, and running the file on another DB.

SELECT 'INSERT INTO table VALUES(', $field1, ',', $field2, ',', $field3, ');';

It's ugly, but once you've got the select statement written the rest of the work is easy.