February 23, 2024

Data is the main asset of modern business. Many companies and organizations are constantly looking for most efficient DBMS for storing and managing their data. Obviously, personal desktop database management systems such as Microsoft Access cannot provide enough scalability for needs of growing businesses. Here are the main reasons of migration to more powerful and flexible DBMS, for example from MS Accessto MySQL:

  • MySQL is open source
  • MySQL has tight integration with web
  • MySQL has stronger security system based on permissions and roles
  • MySQL provides true multi-user environment

MS Access to MySQL database migration is implementer according to extract-transform-load (ETL) model. All MS Access database objects can be easily migrated with special tools except forms and related Visual Basic code that are converted into web-forms into PHP script manually.

Solutions for automating database migration from MS Access to MySQL include free of charge scripts for IT professionals and turn-key commercial tools. It is important to choose the right solution among others based on the following factors:

  • All modern versions of MySQL and its forks such as MariaDB and Percona must be supported
  • The migration tool must handle MS Access databases protected by password or user-level security
  • Main database objects such as tables, data, indexes, relationships between tables and queries must be migrated
  • Optionto export database from MS Access to MySQL script file must be supported
  • The converter must be able to merge or synchronize existing MySQL database with MS Access data
  • Command line support for more flexible use of the product

One of MS Access to MySQL converters meeting these requirements is offered by Intelligent Converters, software company working in database migration field since 2001. One more powerful feature of this product is migrating result of SELECT-queries. This flexible capability can be used for the following purposes.

  • Extracting and renaming particular columns: SELECT FName as FirstName, LName as LastName FROM TheTable
  • Do not migrate records containing NULL values:SELECT * FROM TheTable WHERE not isnull(Comments)
  • Migrating data from multiple MS Access tables into single one:

SELECT T1.code, T1.name, T2.description FROM Products T1 INNER JOIN ProductLines T2 ON T1.productline = T2.productline;

MS Access to MySQL converter has easy-to-use interface that makes it accessible not only for database professionals. The product is supplied with trial version for evaluation purpose, it converts only 50 records per table and does not convert relationships between tables and queries.

Learn more about MS Access to MySQL converter at the product’s homepage on the official site of Intelligent Converters.