The following information is to be used with ssdc.exe
######################
# COMMAND LINE BASICS
######################
Please note that when passing a command line option that conatins special
characters or SPACES, the option MUST BE DOUBLE QUOTED.
Example:
ssdc -outdir "c:\network detective"
######################
# RECOMMENDED
######################
It is recommended that you use the SqlServerDataCollector.exe to produce the command
line switches. On the Verify and Run screen, click the "Save Settings to File"
link. Then from the command line you can run:
ssdc -file <your saved file>
######################
# SWITCH DETAILS
######################
Switch: -v
Details: Get the version of the program.
Switch: -encrypt <password>
Details: Encrypt a password. Used to produce the string to be used by options
that accept encrypted password.
Switch: -file <filename>
Details: Gets other command line parameters from the specified file.
Note 1: Each paramter must be on a single line. Please note that a switch that
takes a value counts as two parameters. Using -outbase for example,
-outbase will be on a single line, then <basename> will on on its own line.
Note 2: Any other switches used with -file WILL TAKE PRECEDENCE over the switches
contained in filename.
Switch: -comment <comment text>
Details: Set the working directory for the output. This directory will be used
for tmp storage and file generation.
Example: -comment "This is for MY COMPANY"
Switch: -outbase <basename>
Details: The basename of the outfile.
Default: SqlServerDataCollection-<timestamp>.ddf
Switch: -outdir <directory>
Details: The directory to produce the final DDF. Defaults to the current
directory.
Switch: -user <username>
Details: User name to be used to connect to the SQL Server.
Default: sa
Note: If -user is NOT used, -auth will default to windows.
Switch: -epwd <password>
Details: The ENCRYPED password for the SQL Server user.
Note: If both -epwd and -pwd are specified, only the encrypted one will
be used.
Switch: -pwd <password>
Details: The NON_ENCRYPTED password for the SQL Server user.
Note: If both -epwd and -pwd are specified, only the encrypted one will
be used.
Switch: -server <host or ip>
Details: Hostname or IP Address of the SQL Server.
Default: localhost
Switch: -port <port>
Details: The port number of the SQL Server.
Default: 1433
Switch: -test
Details: Tests a connection to the SQL Server. No data is collected.
Switch: -auth <sql | windows>
Details: The authentication mode used to connect to the sql server.
Default: sql if the -user switch is used, otherwise windows
Note 1: If using windows authentication mode, the user name and
password switches will be ignored.
Note 2: This switch really does not need to be used. It can be controlled
by either using or not using the -user switch.