Migration from Oracle to MySQL
Posted by: Pedro Rodrigues
Date: December 23, 2009 11:04AM

Hi all,

i'm trying to migrate a set of tables from an Oracle Schema to a new MySQL DB, i'm using MySQL Migration toolkit and I could migrate data from one DB to another but, in MySQL the Database as latin1_swedish_ci Collation and when tables are created, it creates with column collate Latin1_bin, not with latin1_swedish_ci, this results in data truncation for some column fields.

What I did is export the Create table script to TXT file and adapt it by hand, than completes the Migration tool process and all seems OK, because if I create Database tables by hand, all columns are created with latin1_swedish_ci.

Someone goes throw this? How can I use Migration ToolKit to "automatic" export and import data from ORACLE to MySQL regarding this collation issues?

hope someone can help me.

Best regards an Merry Christmas to all of you.

Pedro Rodrigues

Options: ReplyQuote

Written By
Migration from Oracle to MySQL
December 23, 2009 11:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.