SQL Server Migration for Access

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.

This release now supports Microsoft Office Access 2007 databases.

This release supports Office Access 2007 databases and automates migration to SQL Server 2008.

Get the free, easy-to-use tool to simplify the migration process and bring data management, rich data analysis, and data-mining capabilities to your business.

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.

Learn when to use Microsoft Access and when to use SQL Server in your organization. This white paper 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.

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.

Find partners that provide services and tools for the migration of Access databases to SQL Server.