Migration for Microsoft Access

Microsoft Access is a database intended for small projects with a few users. When a database grows large, and more users need to work with it, you are ready to move up to the more robust and secure database solution provided by Microsoft SQL Server. This page provides the tools and resources to help you simplify the process of migrating Access to SQL Server. For more information, read Microsoft Access or SQL Server 2005: What's Right in Your Organization?

On this page:

SQL Server Migration Assistant for Access (SSMA for Access)
Learn about SSMA Access
White Papers
Case Studies
Partners

SQL Server Migration Assistant for Access (SSMA for Access)

Migrate Your Data from Access to SQL Server

Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access versions 97 through 2007 to Microsoft SQL Server. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.

New! Download SSMA 2005 for Access v4.0
This release now supports Microsoft Office Access 2007 databases.
New! Download SSMA 2008 for Access v4.0
This release supports Office Access 2007 databases and automates migration to SQL Server 2008.
Download SSMA for Access v1.2
Simplify the migration process and bring data management, rich data analysis, and data-mining capabilities to your business.

Top of Page

Learn about SSMA Access

Leverage these resources to see how SQL Server Migration Assistant automates, streamlines, and simplifies data migration and helps bring data management, rich data analysis, and data-mining capabilities to your business.

Top of Page

White Papers

Microsoft Access or SQL Server 2005: What's Right in Your Organization?
Learn when to use Microsoft Access and when to use SQL Server in your organization. This white aper discusses database needs, evolution, and challenges;, the advantages, limitations, and myths of Access;, and how to use Access and SQL Server strategically in your organization.
Optimizing Microsoft Office Access Applications Linked to SQL Server
If you want to create applications that use Microsoft Access for the user interface and Microsoft SQL Server for data storage, you can link Access tables to SQL Server tables with SQL Server Migration Assistant for Access. This white paper presents techniques for improving performance and updatability in Office Access applications that use tables linked to SQL Server.