CODEWITHSUNDEEP
mysqlms-accessmysql-workbench
bubble
bubble

Reputation: 3526

How to export MS Access database along with schema?

I have got a database in MS Access format and I want to export it to MySQL. I used this tool to import the database to MySQL successfully. However when I try to do "Reverse Engineer" in MySQL Workbench to draw its schema, all I get is tables without relationhip links. Is there something I am missing?

Upvotes: 0

Views: 763

Answers (1)

Mike Lischke
Mike Lischke

Reputation: 53337

Relationships can only be drawn for foreign keys. If you don't have foreign keys (e.g. only MYISAM tables) then you won't get any relationship. Try the migration module from MySQL Workbench to see if that gives you more in your target schema (tho no promises). If all fails you have to manually add foreignkeys and thereby getting relationships.

Upvotes: 1

Related Questions