MySQL Forums
Forum List  »  IBM DB2

Force migrate to Lower Case?
Posted by: Felix Planjer
Date: December 13, 2007 09:42AM


I'm migrating from a DB2 database to MySQL.
I've managed to get all the data and structure into the MySQL database, using the migration tool (generic JDBC to MySQL). I run into some problems running the application that is using the database.

As it appears the application that we are running is expecting all tables and columns to be in lowercase.
I the set lower_case_table_names option to 1, so all tables get created with lowercase, but all columns are still created in uppercase.

Is there an option in the migration tool to force everything to be created in lowercase? If not, is there a script or tool that can change all column names to lowercase after the migration?

Regards, Felix

Edited 1 time(s). Last edit at 12/14/2007 05:56AM by Felix Planjer.

Options: ReplyQuote

Written By
Force migrate to Lower Case?
December 13, 2007 09:42AM

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.