Migrating a Microsoft Access database to MySQL

http://25yearsofprogramming.com/blog/2010/20100718.htm

25 Years of Programming
An open source source for C, C++, OWL, BASIC, MDB, XLS, DOT, and more...

Home Projects Sitemap Search Blog Forum+Chat About Us Privacy Terms of Use Feedback FAQ Images Services Payments Humor Music

Translate
Select Language
Gadgets powered by Google

Big Book of S.AP Upgrades Get The Big Book of SAP Upgrades. Dozens of Real-World Tips For Free! Legacy Modernization Rehost/replatform Natural programs and data - lower TCO up to 80% VSAM-SQL Server Migration Migrate VSAM To SQL Srvr With Ease NeoData Can Help. Rapid ROI.

PanayaInc.com/Big_Book_of_Upgrad

www.clerity.com www.alchemysolutions.com

Migrating a database from Microsoft Access to MySQL
There are basically four ways to migrate a database from Access to MySQL: 1. Use a MySQL (or other) utility program to pull the structure and data out of the .mdb file. 2. Use Access to push the structure and data into a MySQL database via ODBC. 3. Create the new empty MySQL database and its table structures manually with hand-coding; export the data from Access to a text file; import from the text file to MySQL. 4. Use a commercial converter program.

1) Pull the structure and data out of an .mdb file
Windows
I found the now-deprecated MySQL Migration Toolkit to be very helpful for migrating about 15 databases from Access to MySQL. The version I had was for Windows. After I changed a couple of global settings in Access and a couple of specific settings in the .mdb file to be migrated, the Migration Wizard read from the .mdb file, created corresponding table definitions using MySQL data types equivalent to the Access ones, and transferred all the table data. Although it was nearly 100% unsuccessful at migrating Access Queries to MySQL Views (I did that by manually copying the SQL code out of Access and hand-editing it), the Migration Toolkit's ability to migrate the tables