migrate from oracle

[jjpetrucelli]

i have an oracle db and i would like to recrete and modify the db in mysql and then transfer the data from oracle to mysql. What is the best way to do this? i know there are programs out there but i hear that they dont do a 100%? suggestions?

 

[ingresman]

transfer should be straight forward as long as you dont have bizare data types etc.
You will have problems if the oracle has any pl/sql procedure, packages etc.
Constraints and triggers will cause you issues.
The applicastion will probabbly behave differently as oracle and mysqlhave differecnt query strategies, key types,locking etc etc.

 

[jjpetrucelli]

so whats the easiest way to just get the data from one db to another? Lets not talk the db structure itself.

 

[Bastien]

Export the Oracle to csv and import the csv...you should also be able to take the create statements from Oracle and apply those, likely with a few changes to run on mysql

Bastien

Cat, the other other white meat