I want to automate the process of seeding the staging DB with production-based data, but I need to do some data scrubbing to remove sensitive information (billing, contact info, etc).
It seems to be a common use case and I was expecting to find some good practices or recommended solutions for it, but honestly I couldn't find much.
I'm currently using PostgreSQL hosted in AWS RDS.
The alternatives I'm evaluating now are:
- dump using
pg_dump, restore usingpsqland do some manual modification using python/django script. - AWS has a Database Migration service that might do the trick (https://aws.amazon.com/dms/)
Do you guys know any other tools for this use case?
Thank you.