Migrating Access Databases to SQL Server 2008

Q: I’m trying to migrate a Microsoft Access 2007 database to SQL Server 2008. However, I found that Access’ built-in Database Upsizing Wizard doesn’t work with SQL Server 2008. How do I migrate my Access database to SQL Server 2008?

A: Microsoft released a new set of tools for converting various databases to SQL Server 2008. The new tools are a collection of programs called the SQL Server Migration Assistant (SSMA) 2008.  One of these tools is SSMA 2008 for Access, which you can download from www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en. Other migration assistants include SSMA 2008 for Oracle and SSMA 2008 for Sybase ASE.

Please or Register to post comments.

What's Database Administration Blog?
Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×