| title | Working with SSMA for Access Console (AccessToSQL) | |
|---|---|---|
| description | Working with SSMA for Access Console (AccessToSQL) | |
| author | nilabjaball | |
| ms.author | niball | |
| ms.reviewer | randolphwest | |
| ms.date | 12/30/2025 | |
| ms.service | sql | |
| ms.subservice | ssma | |
| ms.topic | concept-article | |
| ms.collection |
|
SQL Server Migration Assistant (SSMA) for Access is now accessible through a console application at command line. The script files form the input to the application for executing the commands. As a console application, SSMA enables script-level interfacing, reduces the migration cycle, and scales the migration effort.
This section explains the procedure for migrating an Access database by using the SSMA Console application.
| Article | Description |
|---|---|
| Get started with the SSMA Console | Explains the procedure to execute the console application. |
| Command-line options in the SSMA Console | Describes the command line options and parameters to operate the SSMA Console application. |
| Create script files | Explains how to create a script file. |
| Create variable value files | Explains how to create a variable value file. |
| Create the server connection files | Explains how to create a server connection file. |
| Execute the SSMA Console | Describes the script file commands to operate the SSMA Console application. |
| Work with sample scripts in the SSMA Console | Describes the way to easily customize the scripts that have been provided in the sample files along with the product. |
| Manage passwords | Describes about password encryption and decryption, and importing/ exporting password information. |
| Generate reports | Lists the commands to generate reports. |
| Troubleshooting | Provides brief information about fixing migration issues. |