YAML for MSSQL CLI
Execute MSSQL (sqlcmd) commands on a Microsoft SQL Server database.
YAML examples for MSSQL CLI
Execute MSSQL commands
yaml
- action: "Run MSSQL queries"
type: "MSSQL_CLI"
trigger_time: "ON_EVERY_EXECUTION"
shell: "BASH"
commands: |-
sqlcmd -Q 'SELECT @@VERSION'
sqlcmd -i migrate.sql
setup_commands: "apt-get update"
targets:
- target: my_mssql_database
type: MSSQL
name: My MSSQL Database
host: mssql.example.com
port: '1433'
database: app
auth:
username: app_user
password: secured