This repository has been archived by the owner on Jul 1, 2021. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 24
target_sql
Marcel Kloubert edited this page Nov 1, 2017
·
10 revisions
Executes SQL scripts.
{
"deploy": {
"targets": [
{
"type": "sql",
"name": "My SQL server",
"description": "My SQL target",
"engine": "mysql",
"options": {
"host": "mysql.example.com",
"user": "dbUser",
"password": "P@assword123!",
"database": "myDatabase"
}
}
]
}
}
Name | Description |
---|---|
encoding |
The text encoding of the SQL files. Default: utf8
|
engine |
The engine to use. Default: mysql
|
options |
The options for the connection. |
sqlFilesOnly |
Use .sql files only or not. Default: (true)
|
transformer *
|
The path to the script that transforms data before it is executed. |
transformerOptions |
Optional data for the transformer script. |
* supports placeholders
Name | Description |
---|---|
mysql |
MySQL |
sql |
Microsoft SQL |
Name | Description |
---|---|
database |
The database to connect to. |
host |
The host. Default: 127.0.0.1
|
port |
The TCP port. Default: 3306
|
password |
The password. |
rejectUnauthorized |
Reject untrusted SSL connections or not. |
user |
The username. Default: root
|
Name | Description |
---|---|
database |
The database to connect to. |
driver |
The driver to use (for more information s. mssql). Default: tedious
|
encrypt |
Encrypt the connection or not. Default: (false)
|
host |
The host. Default: 127.0.0.1
|
port |
The TCP port. Default: 1433
|
password |
The password. |
user |
The username. Default: sa
|