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 (11.x) through SQL Server 2022 (16.x) on Windows and Linux, or Azure SQL Database. SSMA for Access converts Access database objects to SQL Server or Azure SQL objects, loads those objects into SQL Server or Azure SQL, and then migrates data from Access to SQL Server or Azure SQL.
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 or Azure SQL Database. |
| 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. |