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.
SQL Server Data Collector Command Line options
Have more questions?
Was this article helpful?
Provide feedback for the Documentation team!
Browse this section
- SQL Error - Exception has been thrown by the target of invocation
- Can I run the SQL Server Data Collector on a hosted database, say at Rackspace?
- How large of a SQL Server can you run the SQL Server Data Collector on?
- Can I run the SQL Server Data Collection during business hours with load?
- How long does an SQL Server Data Collection take?
- What type of credentials do I need to run the SQL Server Data Collector?
- Why does the user need 'sa' like priviledges for the SQL Server Data Collection?
- What is the default port the SQL Server Data Collector will connect to?
- I am missing some data from the SQL Server Data Collection
- What versions of SQL Server does the SQL Server Data Collector work on?
- See more