The EC-SQLServer plugin interacts with the Microsoft SQL Server command line tool called
osql tool allows the user to perform sql statements against the database. For example, you can execute a single sql file or execute a query from a text area. Moreover the postp feature is available.
More information about Microsoft SQL server can be found at here.
Plugin Version 22.214.171.1240102903 Revised on June 15, 2020
|For all parameter descriptions below, required parameters are shown in bold italics.|
Plugin configurations are sets of parameters that apply across some or all of the plugin’s procedures. They are intended to reduce repetition of common values, create predefined sets of parameters for end users, and to securely store credentials where needed. Each configuration is given a unique name that is entered in designated parameters on procedures that use them.
Plugin configurations are created by navigating to CloudBees CD. On the right side of the line for the specific plugin, there is a "Configure" link which will open the Configuration page.
Provide a unique name for the configuration. (Required)
Provide the user login ID. Remember that login IDs are case sensitive.
Provide the user-specified password
RunSQLFile procedure creates and executes a command line from the parameters you provide in the procedure form, This command line will call the SQL Server’s utility called osql.exe
Path to osql.exe
Absolute path to the Sql Server utility osql.exe
The name of the server you want to connect to. (This is the command-line '-S' option) (Required)
Provide any sql statement to run against the database. (This is the command-line '-Q' option)
Issues a USE db_name statement when osql is started. (This is the command-line '-d' option)
Path to a sql file
Absolute path to a sql file. (This is the command-line '-i' option)
The name of the configuration that contains the SQL Server user and password.
Result (output property path)
Property name used to store the result of queries.