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

Avoid awaiting your test data

Continuous Test Data Management (TDM)   Accelario is a unique Test Data Management software solution, tailored specifically for Dev & QA teams requirements. With Accelario

Read More »