| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Server Migration Assistant for Access (AccessToSQL) |
Learn about SSMA for Access and follow step-by-step instructions for migrating Access databases to SQL Server or Azure SQL Database. |
cpichuka |
cpichuka |
randolphwest |
07/10/2023 |
sql |
ssma |
conceptual |
|
|
[!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.
| 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 [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb]. |
| 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 [!INCLUDE ssNoVersion]. |
| 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. |