Synthesized TDK MS SQL Server Demo

Clone this repo:

git clone https://github.com/synthesized-io/pagila-tdk-demo
cd tdk-demo/mssqlserver

Masking of the existing data

Run TDK:

export CONFIG_FILE=config_masking.tdk.yaml
docker compose run tdk

Execute control_query.sql script on the original database:

usql ms://sa:Secret_password_1@localhost:6000/northwind -f control_query.sql

Execute control_query.sql script on the masked database:

usql ms://sa:Secret_password_1@localhost:6001/northwind -f control_query.sql

Run TDK:

export CONFIG_FILE=config_generation.tdk.yaml
docker compose run tdk

Execute control_query.sql script on the original database:

usql ms://sa:Secret_password_1@localhost:6000/northwind -f control_query.sql

Execute control_query.sql script on the resulting database:

usql ms://sa:Secret_password_1@localhost:6001/northwind -f control_query.sql