Access to MySQL

What This Book Covers

MySQL is the world's most popular open-source database and a strong choice for web-focused Access migrations. This book covers the complete migration process, from installation through reconnection and troubleshooting.

Includes MySQL Workbench migration wizard walkthrough, Bullzip Access to MySQL usage, manual migration with Python scripts, MySQL-specific SQL dialect differences, ODBC Connector setup, and performance tuning for workloads that were designed for Access.

Complete Table of Contents

• Part I: Before You Start
• Chapter 1: Pre-Migration Assessment
• Chapter 2: Installing and Configuring MySQL
• Part II: The Migration
• Chapter 3: Schema Migration
• Chapter 4: Data Migration
• Chapter 5: Query Migration
• Chapter 6: VBA Code Updates
• Chapter 7: Reconnecting the Access Front-End
• Part III: After the Migration
• Chapter 8: Testing and Validation
• Chapter 9: The 50 Most Common Post-Migration Issues
• Chapter 10: Performance Tuning
• Chapter 11: Backup, Security, and Ongoing Administration
• Appendices
• Appendix A: Complete Data Type Mapping Reference
• Appendix B: Access SQL to MySQL Function Reference
• Appendix C: Connection String Reference
• Appendix D: Pre-Migration Checklist
• Appendix E: Post-Migration Validation Checklist
• Appendix F: VBA Relink Script

Get Access to MySQL

11 chapters, 6 appendices. The complete MySQL migration guide.

$29.99