Skip to content

Latest commit

 

History

History
48 lines (35 loc) · 1.03 KB

README.md

File metadata and controls

48 lines (35 loc) · 1.03 KB
Raw

Synthesized TDK Oracle Demo

Sakila for Oracle is an Oracle port of the legendary MySQL Sakila sample database.

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

Masking of the existing data

Set up the TDK license key:

export SYNTHESIZED_KEY=kDpeQB...

Note

Please contact us to obtain an enterprise license key.

Spin up Oracle databases:

docker compose up oracle_source oracle_target -d

Run TDK:

docker compose run tdk

Export to PostgreSQL

Run ora2pg to export the masked Oracle database to set of PostgreSQL sql-files:

docker compose run ora2pg

Run the PostgreSQL database:

docker compose up postgres_masked -d

Knowing problems

  • get rid of last_update columns in the cofiguration file
  • truncate shcema with recursive FKs
  • mask the film.description column