Database Management Plugins → SQLCMD Plugin → Creating a Run SQLCMD Scripts Step
This step runs sqlcmd scripts in sorted order.
Required properties: None.
|Directory Offset||Enter the directory offset relative to the current working directory where the step should run.|
|SQLCmd Executable Path||Enter the full path to the sqlcmd executable if it is not on the path.|
|Server\Instance||Enter the server or instance to connect to.|
|Username||Enter the username for the scripts to be run as.|
|Password||Enter the password of the user for the scripts to be run as.|
|Password Script||Use this instead of the Password field if the password is stored in a property.|
|Use Trusted Connection||Select this to use a trusted connection instead of user/password.|
|Use Dedicated Admin Connection||Select this to use a dedicated administrative connection.|
|DB Name||Enter the name of the database to use.|
|SQL File Includes||Enter a new-line-separated list of file filters to determine the SQL scripts to be executed. Use this when order between files is unimportant.|
|Exclude Files||Enter 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 you are using a list in the SQL Files field, this field is ignored.|
|SQL Files||Enter a new-line-separated list of files to be executed. Use this when order between files is important.|
|Login Timeout||Enter the number of seconds before a sqlcmd login to the OLE database provider times out when you try to connect to a server. The default is 8 seconds.|
Copyright © 2013–2016 Serena Software, Inc. All rights reserved.