docker-embulk-sqlserver
This repository is a sample using sqlserver plugin with embulk, it works on Docker.
Usage
Sample Configuration (config.yml)
in:
type: sqlserver
host: localhost
user: myuser
password: ""
database: my_database
table: my_table
select: "col1, col2, col3"
where: "col4 != 'a'"
order_by: "col1 DESC"
filters:
- type: column
columns:
- {name: col1}
- {name: col2}
out:
type: sqlserver
host: localhost
user: myuser
password: ""
database: my_database
table: my_table
mode: insert
You can run embulk from docker-compose
$ docker-compose run --rm embulk run config.yml
Plugin to use
Please refer to here for detailed settings