Access to PostgreSQL

What This Book Covers

PostgreSQL is the most standards-compliant open-source database, with no licensing limits at any scale. It's the best choice for organizations that want enterprise-grade features without enterprise-grade costs — but it has the steepest learning curve for Access developers.

This book bridges that gap with a complete, step-by-step migration guide specifically written for people coming from Access. Covers the PostgreSQL-specific concepts that trip up Access developers, with practical solutions for every common issue.

Complete Table of Contents

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

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

$34.99