| title | SQL Server Migration Assistant for Access (AccessToSQL) | |
|---|---|---|
| description | Learn about SSMA for Access and follow step-by-step instructions for migrating Access databases to SQL Server or Azure SQL Database. | |
| author | nilabjaball | |
| ms.author | niball | |
| ms.reviewer | randolphwest | |
| ms.date | 11/19/2024 | |
| ms.service | sql | |
| ms.subservice | ssma | |
| ms.topic | conceptual | |
| ms.collection |
|
|
| f1_keywords |
|
[!INCLUDE msCoName] [!INCLUDE ssNoVersion] Migration Assistant (SSMA) for Access is a tool for migrating databases from [!INCLUDE msCoName] Access versions 97 through 2010, to [!INCLUDE sssql11-md] through [!INCLUDE sssql22-md] on Windows and Linux, or [!INCLUDE ssazure-sqldb]. SSMA for Access converts Access database objects to [!INCLUDE ssNoVersion] or Azure SQL objects, loads those objects into [!INCLUDE ssNoVersion] or Azure SQL, and then migrates data from Access to [!INCLUDE ssNoVersion] or Azure SQL.
This documentation introduces you to SSMA for Access and provides step-by-step instructions for migrating Access databases to [!INCLUDE ssNoVersion] or Azure SQL Database and information about issues that might occur after migration.
| Article | Description |
|---|---|
| What's new in SSMA for Access (AccessToSQL) | Lists the changes to SSMA releases. |
| Install SQL Server Migration Assistant for Access (AccessToSQL) | 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 (AccessToSQL) | Describes how to prepare your Access databases for conversion to [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb]. |
| Migrating Access databases to SQL Server - Azure SQL Database (AccessToSQL) | Provides an overview of the conversion process and detailed information about each step in the process. |
| Linking Access applications to SQL Server - Azure SQL Database (AccessToSQL) | Describes how to use your existing Access applications with [!INCLUDE ssNoVersion]. |
| User Interface Reference (AccessToSQL) | Contains documentation for SSMA dialog boxes. |
| Working with SSMA for Access Console (AccessToSQL) | Contains documentation on the SSMA console application. |
| SQL Server Migration Assistant | Provides information about getting more assistance. |