Working with SSMA for Access Console (AccessToSQL)
Applies To: Azure SQL Database, SQL Server
Microsoft 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 to migrate the Access database using the SSMA Console application.
Topics covered in this section include:
|Getting Started with SSMA for Access Console (AccessToSQL)||Explains the procedure to execute the console application.|
|Command Line Options in SSMA Console (AccessToSQL)||Describes the command line options and parameters to operate the SSMA console application.|
|Creating Script Files (AccessToSQL)||Explains how to create a script file.|
|Creating Variable Value Files (AccessToSQL)||Explains how to create a variable value file.|
|Creating the Server Connection Files (AccessToSQL)||Explains how to create a server connection file.|
|Executing the SSMA Console (AccessToSQL)||Describes the script file commands to operate the SSMA console application.|
|Working with the Sample Console Script FilesExecuting the SSMA Console (AccessToSQL)||Describes the way to easily customize the scripts that have been provided in the sample files along with the product|
|Managing Passwords (AccessToSQL)||Describes about password encryption and decryption, and importing/ exporting password information.|
|Generating Reports (AccessToSQL)||Lists the commands to generate reports.|
|Troubleshooting (AccessToSQL)||Provides brief information about fixing migration issues.|