Ms. Access to MySQL: lost Foreign Keys
Posted by: Marti
Date: July 20, 2005 03:55AM

Hi,

When migrating a Microsoft Access 2003 database to MySQL, using the latest MySQL Migration Toolkit (version 1.0.10 beta). I get satisfactory results, except for the foreign keys. Only one foreign key per table is created.

In the ‘Manual editing’ step of the tool, selecting the ‘Show All Objects with Messages’ filter, I can see all the foreign keys with the ‘Migration message’: ‘Object migrated successfully’. But if I switch to the ‘SQL Create Script of Selected Object’, only one foreign key is created as a constraint, while the others are created as an index.

I don’t know if it’s a known limitation or if I missed something. Anyone could help me?

Thanks,

Martí

Options: ReplyQuote


Subject
Written By
Posted
Ms. Access to MySQL: lost Foreign Keys
July 20, 2005 03:55AM


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.