lundi 1 octobre 2018

Ready-made sql queries to turn sensitive data into test data in a mysql database

I'm looking for ready-made sql queries to modify anything that can be recognized in a database into a test database. Let me explain: I would like to give the database to a website developper after modifying it in a test database but keeping the number of records in each table, and also keeping the type and the similarity of the data .

Is there any application or a set of queries provided for this purpose, to modify all the strings concerning names by changing a few letters (for example, replace the vowels with other random vowels), or change the dates of birth (by randomly incrementing or decreasing the dates of a certain number of days). In this way any processing on the database will use test data that will have the same advantages or disadvantages as the original data for development.

so I thought I was probably not the first one to think about it;)

Thanks for your ideas!

Aucun commentaire:

Enregistrer un commentaire