Summary

In this chapter, we migrated a backend database to MySQL using manual techniques. We learned when we can and cannot use automated methods directly from MS Access, depending on the versions and bit versions of MS Access and MySQL. Then, we learned how to migrate an MS Access database to MySQL using MySQL Workbench. Finally, we linked the MS Access application to the new MySQL server tables and proved that the application still works.

Now that we have migrated our test database to MySQL, in the next chapter, we will migrate the MS Access application to MySQL to leverage the power of MySQL.