Access to MariaDB

What This Book Covers

MariaDB is the community-driven fork of MySQL, free from Oracle's ownership and increasingly popular as a cost-effective database choice. This book covers migrating from Access to MariaDB, leveraging MySQL compatibility while taking advantage of MariaDB-specific improvements.

If you've considered MySQL but want to avoid Oracle's licensing model, or if your Linux distribution ships MariaDB by default, this guide covers the specific differences you'll encounter and how to handle them.

Complete Table of Contents

• Part I: Before You Start
• Chapter 1: Pre-Migration Assessment
• Chapter 2: Installing and Configuring MariaDB
• 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 MariaDB 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 MariaDB

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

$29.99