Database Management Plug-ins → SQLCMD Plug-in → Creating a Run SQLCMD Scripts Step
This step runs sqlcmd scripts in sorted order.
Required properties: None.
|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.
|Enter the server or instance to connect to.
|Enter the username for the scripts to be run as.
|Enter the password of the user for the scripts to be run as.
|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.
|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.
|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.
|Enter a new-line-separated list of files to be executed. Use this when order between files is important.
|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.