Foreign keys lost after converting from ACCESS to MySQL

General usage of Access to MySQL

Moderator: jr

Post Reply
frank.quosdorf
Posts: 1
Joined: Fri Aug 22, 2008 12:41 pm

Foreign keys lost after converting from ACCESS to MySQL

Post by frank.quosdorf »

After converting from ACCESS (2003) to MySQL (INNODB, MySQL 5.1), all foreign keys (references) are lost. Is there a setting that needs to be configured?

Thanks, Frank
jr
Site Admin
Posts: 500
Joined: Sun Mar 26, 2006 12:28 pm

Re: Foreign keys lost after converting from ACCESS to MySQL

Post by jr »

Primary and secondary indexes should be moved to MySQL.

Regards,
Jacob
Pegsneggle
Posts: 3
Joined: Thu Oct 23, 2008 12:10 pm

Re: Foreign keys lost after converting from ACCESS to MySQL

Post by Pegsneggle »

I have the same problem. As far as I can see, there is only one reference to index during the conversion process. I have made sure the tick remains in that box, but still no foreign key settings are created. What am I doing wrong?
Post Reply