Force migrate to Lower Case?

[Felix Planjer]

Hi,

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.