Get Cozi - it's free!

Cozi Family Organizer

Our Blog

Importance of online study for a college student

Nowadays, the challenges facing traditional colleges and universities are budget cuts and course shortages. They end up making students search for alternatives. With the internet as the ultimate education resource, and students even getting…

Travelling Abroad With Kids: Our Guide To A Stress-Free Trip

When you are travelling with kids, it can be easy to get very stressed out. You have so many people to handle and travelling is already quite a stressful experience. Of course, families love to travel abroad and it is all worth it once you get to your hotel and are able to relax. As long as you handle the journey well,…



Place your ad here.

Database Migration from MS Access to MySQL

The primary purpose of using Microsoft Access is a desktop database management system. Such systems can handle small and medium size databases and allow multi-user access over the network. However, MS Access has scalability issue since it does not support client-server architecture that is common for enhanced database management systems. This fact prevents growing companies from using Microsoft Access and also forces to migrate their data to MySQL as more powerful and reliable DBMS that does not require much expenses for deployment.

Top Reasons for Migration

Organizations and end users may want to migrate from MS Access to MySQL due to the following benefits of the destination DBMS:

MySQL can work as back-end for MS Access that allows to continue using Microsoft Access as user friendly interface
MySQL is the best choice to integrate database with web servers like Apache in order to create data-driven sites, catalogues or corporate portals
MySQL supports any modern languages like C++, PHP, Perl, Python and many others. DBMS components and APIs are free and work on all popular platforms
MySQL can handle many simultaneous connections to database through native client-server architecture
MySQL provides sophisticated system of privileges for more control over user roles and permissions
MySQL has open source distribution with a lot of free tools and frameworks. Migration to MySQL can reduce total cost of the ownership (TCO)

Approaches to Migration from MS Access to MySQL

There are multiple options to migrate Microsoft Access database to MySQL server: some of them require essential human efforts to post-process the resulting database while others perform turn-key automated conversion. The most straight forward approach to migration is to extract the data from MS Access database into temporary storage, convert it according to MySQL format and load into the destination database. There are few other methods to migrate from MS Access to MySQL with less manual efforts listed below.

Export Data using Microsoft Access

MS Access can handle data migration itself since it allows exporting data into plain text file. MySQL allows to import this data either by running ‘LOAD DATA’ statement or special tool mysqlimport. Although this method does not require a special software, MySQL tables must be manually created before starting the procedure.

MySQL Scripts Generation

Another popular method to migrate MS Access database to MySQL is direct export of the original database into MySQL statements creating tables, indexes, constraints and inserting the data. After this export is completed, database specialist has to import the resulting script into MySQL database using standard tools.

Commercial Migration Tools

The simplest way to migrate from MS Access to MySQL is to use dedicated commercial tools that can automate entire procedure with just a few clicks of mouse button. It is better to use migration tools that support command line since it allows to script and schedule the procedure. Intelligent Converters, a software company specializing in database migration since 2001, offers such tool having all necessary features to process even large and complicated data.

Visit to learn more about Microsoft Access to MySQL converter.

Views: 18


You need to be a member of Mom Bloggers Club to add comments!

Join Mom Bloggers Club

© 2019   Created by Mom Bloggers Club.   Powered by

Badges  |  Report an Issue  |  Terms of Service