Edit

Appendix - 1 (MySQLToSQL)

  • Article

Quick view of the SSMA Console command line options:

Sl. No. Switch Required? Switch Argument Permitted Values
1 -s/script Yes scriptfile Valid XML file name.

Console Script definition file.
2 -v/variable No variablevaluefile Valid XML file name.

If variables are used in script file, then this file must be specified.
3 -c/serverconnection No serverconnectionfile Valid XML file name.

This file contains server connection information.
4 -x/xmloutput No xmloutputfile This option indicates console output in the XML format. If this option is not specified, the default output is in TEXT format.

If xmloutputfile is not specified, XML output is directed to STDOUT.

Xmloutputfile is the name of the file to which the console output is written in the XML format.
5 -l/log No logfile Valid file name.
6 -e/projectenvironment No projectenvironmentfolder Valid folder name containing SSMA project environment files.
7 -p/securepassword No -a/add {<server_id> [,...n] | all} -c|serverconnection <server-connection-file> [-v|variable <variable-value-file>] [-o/overwrite]

or

-a/add {<server_id> [,...n] | all} -s|script <script-file> [-v|variable <variable-value-file>] [-o/overwrite]

-r/remove {<server_id> [, ...n] | all}

-l/list

-e/export {<server-id> [, ...n] | all} <encrypted-password -file>

-i/import {<server-id> [, ...n] | all} <encrypted-password-file>		 If specified, this option must not be combined with any other options.

server-id: A unique ID provided for a server {string}

server-connection-file: server definition file (serverconnectionfile or scriptfile).

variable-value-file: It is a variable definition file and used in server-connection-file.

encrypted-password-file: It is a server passwords file encrypted using a user-specified pass-phrase.
8 -? No Not Applicable Not Applicable

See Also

Executing the SSMA Console (MySQL)