I have a .mdb file on my computer that I would like to convert into a MySQL Schema and I have found that there is a migration tool within Workbench. However it doesn't seem to allow you to connect to a .mdb instead it looks for a server. How should I either link to my file or host my file easily as I have not done this before.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You can use MySQL Workbench to connect and migrate your schema/data from MS Access to mySQL. First you need to configure an ODBC Data Source:
Back on MySQL Workbench: Use the menu
As a supplement the response @marcelo-rodrigo, you can use Workbench or another tool but you will need to export table relations too (Workbench and other tools doesn't exports relations)
I write a code to extract all table relations from MS-Access database as SQL and run it on MySQL after export. Link to Code at Github Gist.