The Microsoft SQL Server SQLCmd plug-in automates the execution of the Microsoft
This plug-in includes one step:
This plug-in requires IBM UrbanCode Deploy version 6.0 or later.
This plugin supports Microsoft SQL Server 2012, 2014, and 2016+.
This plug-in runs on the Windows operating systems that UrbanCode Deploy supports.
Note: The SQL-JDBC plug-in can be used to deploy to Microsoft SQL from a Linux agent.
No special steps are required for installation. See Installing plug-ins in UrbanCode Deploy.
Updated SQLCmd Executable Path description for clarity.
Added an Additional Arguments field to support SQLCmd 2014 and 2016+.
Support property file encryption.
Fixes APAR PI35342 compatibility defect with IBM Urbancode Deploy version 22.214.171.124 and later.
Run SQLCmd scripts in sorted order
|Additonal Arguments||String||Specify additional command line arguments in the format: FLAG [VALUE].
Each Flag, and poential Value, should be separated with a space. Example: -v MyVar1=something
or -N. Separate each argument pair with a new line or semicolon.
|DB Name||String||The name of the DB to use.||No|
|Directory Offset||String||The directory offset relative to the current working directory where the step should
|Exclude Files||String||A new line separated list of file filters to determine the files to be excluded from
the above selection. Use in conjunction with includes. If using list it is ignored.
|Login Timeout||String||Specifies the number of seconds before a sqlcmd login to the OLE DB provider times
out when you try to connect to a server.Defaults to 8 sec if
|Password||Password||The password of the user for the scripts to be run as.||No|
|Password Script||String||Use this instead of the Password field if the password is stored in a property.||No|
|SQL File Includes||String||A new line separated list of file filters to determine the sql scripts to be executed.
Use this when order between files is unimportant.
|SQL Files||String||A new line separated list of files to be executed. Use this when order between files
|SQLCmd Executable Path||String||The full path to the sqlcmd executable if it is not in the current working directory,
and if it is not specified in the PATH environment variable.
|Server\Instance||String||The server\instance to connect to.||No|
|Use Dedicated Admin Connection||Boolean||Select here to use a dedicated admin connection.||No|
|Use Trusted Connection||Boolean||Select here to use a trusted connection instead of user/password.||No|
|User name||String||The user name for the scripts to be run as.||No|