User guide

90
Parameter
Variable
Mandatory?
Description
-UserName
No
User name that will be used for the credentials
to start the service (must be in the form
DOMAIN\USER). If provided, the parameter –
Password must also be provided. If not provided,
the LocalSystem account will be used by default.
Optional for Create and Config actions and
ignored by all others.
To reset the credentials to the LocalSystem,
enter LocalSystem as the user and "" as the
password.
-Password
No
Password of the user name specified to start the
service. Optional for Create and Config actions
and ignored by all others.
-StartMode
No
Start mode of the service. By default, the service
will be created with Automatic. The choices are:
- Manual : Service is started only manually
- Automatic : Service will be started
automatically next time the computer is
restarted
- Disabled : Service is disabled
Optional for Create and Config actions and
ignored by all others.
DACPAC Database Deployment Agent
This tool allows users to deploy a DACPAC package. It is based on a SQL server command line utility. There are a
lot of possible parameters for this executable but we will list only the one used for this tool. Please refer to the
sqlpackage documentation for further information about this utility. The configuration variables of this tool are:
Parameter
Variable
Mandatory?
Description
/Action:
Yes
Fixed value Publish meaning we want to
publish the package.
/SourceFile:
FileName
Yes
The complete path (if required) and file
name of the DACPAC.
/TargetServerName:
ServerName
Yes
The name of the SQL Server where to
publish.