Access to MySQL migration problems
Posted by: Craig Linner
Date: September 23, 2009 07:34PM

Using MySQL Migration Toolkit to migrate MS Access databases to MySQL.
Two problems:

1. Changes all table names to lower case. They are originally in camel case, ie. t_MyTable.
Presents a problem since I have to go through the code in the program that is accessing/using the database and change all references to the tables to lowercase.
Additionally, when I try to change the table names back to camel case using MySQL Administrator it lets me make the change in the edit screen, but does not save the changes, just keeps the lower case names.

2. Does not migrate MS Access saved queries as views which they essentially are. Actually does not migrate them at all.

Is there a way to change/modify these behaviors?
Is there another tool/program that does a better job of migrating?

Thanks for your help,

Options: ReplyQuote

Written By
Access to MySQL migration problems
September 23, 2009 07:34PM

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.