Working with SSMA for Access Console (AccessToSQL)
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:
Explains the procedure to execute the console application.
Describes the command line options and parameters to operate the SSMA console application.
Explains how to create a script file.
Explains how to create a variable value file.
Explains how to create a server connection file.
Describes the script file commands to operate the SSMA console application.
Describes the way to easily customize the scripts that have been provided in the sample files along with the product
Describes about password encryption and decryption, and importing/ exporting password information.
Lists the commands to generate reports.
Provides brief information about fixing migration issues.