MySQL Workbench (versions 5 and 6) contain a Migration Toolkit to convert external databases to MySQL, but Microsoft Access isn't an option. However, it used to be an option in the predecessor tool: MySQL GUI Tools. Fortunately, you can download an archived installer for MySQL GUI Tools here:
http://dev.mysql.com/downloads/gui-tools/5.0.html
With that, if you install MySQL GUI Tools (and install a 32-bit version of the Java JRE 6), if you start the MySQL Migration Toolkit, there is an option to convert from an Microsoft Access database. I chose all of the default settings (except I asked for .sql scripts to be saved), and it converted fine.
No comments:
Post a Comment