Access to MySQL migration problems
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,
Craig
Subject
Written By
Posted
Access to MySQL migration problems
September 23, 2009 07:34PM
December 11, 2009 03:08AM
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.