
Converting database from MS Access to MySQL
Although the conversion process is a tedious task, the MySQL has considerable benefits over the Microsoft Access, most notably: higher performance; multiple user access; cross platforming; and a better security system. To setup a complex or multi-user database system, migration of data from Access to MySQL is therefore highly recommended. However, for a single user system where there is not so large data file involved, the MySQL offers not much difference over the MS Access database.
To migrate data from MS Access to MySQL do the following:
Extract the definitions of MS Access tables, indexes and constraintsand convert them into MySQL format.Then load converted statements to the MySQL database.
Export MS Access data to intermediate storage, make necessary conversions and load it i...