Modules
Sign in
Get Help

SQL Server Data Collector Command Line options

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.         

Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section