We are in the process of migrating from Oracle 8 to MySQL 4.0.13. We have 4 databases that we want to migrate. However I don´t want to migrate the table structure, due to problems with binary types in MySQL. I will re create the table structure in MySQL. However I want to migrate the data from the databases on Oracle. Is there a simple way to do this? Can you dump data to a file and then use some Load Data function in MySQL to insert the data?
I know that there is tools for migration but this tools impose that you migrate both table structure and data, since this is not an option for us we prefer to only migrate data to a new table structure in MySQL (same structure but different data types (binary/varchar)).
// Mattias
I know that there is tools for migration but this tools impose that you migrate both table structure and data, since this is not an option for us we prefer to only migrate data to a new table structure in MySQL (same structure but different data types (binary/varchar)).
// Mattias