Converting ms access to mysql with relationships

Question

I have tried some tools (such as mysql migration toolkit and bullzip's Access To MySQL utility.) that convert a ms access database to mysql which all successfully create the database, tables and insert the data.

What they do not appear to do is recreate the relationships (constaints) from the original ms access database into mysql.

Are there any utilities that can recreate the database, tables and data with the correct relationships? Thanks

Answer 1

Yes, there are tools which do that for you:

• Access to MySQL
• Access-MySQL Converter 3.1

I would always take care using tools like these for conversions, especially relationships - you never know if they forget some relationship or convert fieldtypes wrongly. So you better make sure to manually check everything afterwards.