Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Appendix - 1 (MySQLToSQL)

SQL Server 2012

Quick view of the SSMA Console command line options:

Sl. No.

Switch

Required?

Switch Argument

Permitted Values

1

-s/script

Yes

scriptfile

  1. Valid XML file name.

  2. Console Script definition file.

2

-v/variable

No

variablevaluefile

  1. Valid XML file name.

  2. If variables are used in script file, then this file must be specified.

3

-c/serverconnection

No

serverconnectionfile

  1. Valid XML file name.

  2. This file contains server connection information.

4

-x/xmloutput

No

xmloutputfile

  1. This option indicates console output in the XML format. If this option is not specified, the default output is in TEXT format.

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

  3. 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>

  1. If specified, this option must not be combined with any other options.

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

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

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

  5. encrypted-password–file: It is a server passwords file encrypted using a user-specified pass-phrase.

8

-?

No

Not Applicable

Not Applicable

Show:
© 2015 Microsoft