Moving data from MySQL --> Oracle

[phillydog]

Does anyone know how data could be moved from a MySQL repository to an Oracle repository? I am not sure of the versions, but since the company just got Oracle, I would guess it is the latest version.

This came up as discussion, however, I am not too familiar with databases.

 

[notfred]

Dump the data from mysql to a text file and then import it into oracle?

 

[Nothinman]

Depending on how you setup the MySQL database it should be pretty simple to use mysqldump to dump the data then change whatever is necessary and import it on the Oracle side.

 

[phillydog]

Thanks for the responses. All works fine now.