Forum Discussion
AUG Access Pacific User Group Meeting: Migrating Access Tables to SQL Server, a Comparison of Method
Former Access MVPs Tom Wickerath and George Hepworth will discuss preparing for a migration from Access to SQL Server and demonstrate two tools for doing it.
(Please verify your Time Zone offset for your local start time.)
We'll discuss pre-migration preparations and planning, then take a closer look at two methods for migrating data from your Access tables to SQL Server.
- Scripting tables in VBA and exporting the data from Access to SQL Server -- Tom Wickerath.
- Using SSMA to create tables in SQL Server and migrate data from Access to those tables -- George Hepworth.
In preparing for this presentation, George encountered a bug in the newest version of SSMA (9.3) and reported it. Within 24 hours the SSMA team responded. Within 72 hours they'd released the fix. That kind of response is notable and noteworthy. Don't you wish all of our bug reports could be resolved as efficiently?
Bring your own questions and suggestions for the group. We like to round out a presentation with discussions about real world situations.
If you have ever struggled with migrating data from Access to SQL Server, using SSMA or another approach, please join us. We'll try to explain what to look for, how to prepare for the migration, and how to use the tools.
No RepliesBe the first to reply