User guide

83
A3. TOOLS CATALOG
Database Deployment Agent – Execute Script
This tool allows users to execute a SQL query in a specific database. It is based on the standard sqlcmd executable
distributed with SQL Server. 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 sqlcmd documentation for further information about this executable. The
configuration variables of this tool are:
Parameter
Variable
Mandatory?
Description
-S
ServerName
Yes
The server name of the SQL database.
-i
ScriptName
Yes
The name of the script to be executed.
-b
N/A
No
This parameter is a switch. If present, it means that if
an error occurs, the batch will be aborted.
Reporting Services Deployment Agent
This tool allows users to deploy reporting services reports and related object. It is based on a custom release
management executable. The configuration variables of this tool are:
Parameter
Variable
Mandatory?
Description
-s
serverUrl
Yes
The complete URL of the reporting services server.
-l
itemLocation
Yes if
multiple
items
The location of the items. If specified, the folder must
be provided (-f).
-f
folder
Yes if
multiple
items
The folder of the items. If specified, the item location
must be provided (-l).
-t
Yes
The item type to be processed. The allowed values
are:
- Report
- Picture
-sp
No
List of search patterns to use to filter the items. Each
search pattern must be separated by a comma or a
semicolon (i.e. *.bmp;*.jpg). If not specified, the
search pattern will be defaulted following the
selected item type (-t):
- Report: *.rdl
- Picture: *.bmp,*.gif,*.jpg,*.jpeg,*.png