Export (0) Print
Expand All

SQL Server Migration Assistant for Access (AccessToSQL)

SQL Server 2012

Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005 / Microsoft SQL Server 2008 / Microsoft SQL Server 2012 / MicrosoftSQL Server 2014 / Microsoft SQL Azure. SSMA for Access converts Access database objects to SQL Server or SQL Azure database objects, loads those objects into SQL Server or SQL Azure, and then migrates data from Access to SQL Server or SQL Azure.

This documentation introduces you to SSMA for Access, provides step-by-step instructions for migrating Access databases to SQL Server or SQL Azure, and provides information about issues that might occur after migration.



What's New in SSMA for Access

Lists the changes to SSMA releases.

Installing SQL Server Migration Assistant for Access

Lists the prerequisites for installing SSMA, the procedure for installing and licensing SSMA, and a link to the latest version.

Getting Started with SQL Server Migration Assistant for Access (AccessToSQL)

Introduces SSMA and its user interface.

Preparing Access Databases for Migration

Describes how to prepare your Access databases for conversion to SQL Server /SQL Azure.

Migrating Access Databases to SQL Server

Provides an overview of the conversion process and detailed information about each step in the process.

Linking Access Applications to SQL Server

Describes how to use your existing Access applications with SQL Server.

User Interface Reference(Access)

Contains documentation for SSMA dialog boxes.

Getting SSMA Assistance for Access (AccessToSQL)

Provides information about getting additional assistance.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft