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 SQL Server 2012, Microsoft SQL Server 2014, Microsoft SQL Server 2016, Microsoft SQL Server 2017 on Windows and Linux, Microsoft SQL Server 2019 on Windows and Linux, or Microsoft Azure SQL Database. SSMA for Access converts Access database objects to SQL Server or Azure SQL database objects, loads those objects into SQL Server or Azure SQL Database, and then migrates data from Access to SQL Server or Azure SQL Database.
This documentation introduces you to SSMA for Access and provides step-by-step instructions for migrating Access databases to SQL Server or Azure SQL Database and 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 | Contains documentation on the SSMA Console application |
| Getting SSMA Assistance for Access | Provides information about getting additional assistance. |