Introduction to databases migration from MS Access to MySQL

In past Microsoft Access was quite popular DBMS for small and medium size databases. It has been designed for easy management of structured data stored in the local filesystem. MS Access has intuitive interface and provides easy-to-use tools for database administration and development purposes. Unfortunately, Microsoft Access also has some limitations that prevent from scaling and deploying the system. Most important of them are 2GB max file size, 255 max concurrent users and others. Due to these limitations of MS Access many companies and organizations consider migration to advanced database management…

Read More