Work with SSMA for Db2 console (Db2ToSQL)
The SQL Server Migration Assistant (SSMA) release for Db2 is accessible through a console application at the 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 Db2 database using the SSMA console application.
| Article | Description |
|---|---|
| Get Started with SSMA for Db2 Console | Explains the procedure to execute the console application. |
| Command line options in 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 console script files | Describes the way to easily customize the scripts that are 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. |
| Troubleshoot | Provides brief information about fixing migration issues. |