SQL Server Migration Assistant for Access (AccessToSQL)

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 / Microsoft SQL Server 2014 / Microsoft SQL Server 2016 / 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.

Contents

Section Description
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 Contains documentation for SSMA dialog boxes.
Working with SSMA for Access Console Contain documentation on the SSMA Console application
Getting SSMA Assistance for Access Provides information about getting additional assistance.