Access to SQL Server

What This Book Covers

The most common Access migration path — moving to SQL Server. This book walks you through every step, from installing SQL Server Express to reconnecting your Access front-end to troubleshooting the inevitable issues.

Includes complete SSMA (SQL Server Migration Assistant) walkthrough with screenshots, manual migration methods for when SSMA fails, T-SQL conversion guide for Access-specific SQL, ODBC linked table setup, and solutions for the 50 most common problems that appear after migration.

Complete Table of Contents

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

11 chapters, 6 appendices. The complete SQL Server migration guide.

$29.99