1TB production to 50GB test data for two QA users, in 10 minutes, MySQL

Share on facebook
Share on twitter
Share on linkedin

I have a large production database and need only partial, secured data for two QA users

Source production database is large; 1TB that includes 100 tables and customer sensitive data.

For testing environments we need only a small part of the production database: 4 tables with relevant data from the last 3 months, 50GB. We also need to mask sensitive data. Two different pre-defined workflows are being created for two separate QA users.

Test data total generation time is 10 minutes.

Suggested reading