mysql data masking

Question

Hi I'd like to a take a production database and use it in a private, development environment. But, I'd like to anonymize the data.

I've been searching for an hour, but everything I find is for Oracle or SQL Server... nothing for mysql.

I have approximately 15 tables with 75 fields that should be anonymized.

Has anybody found a recommended solution(s)?

Answer 1

I understand from Gartner that Camouflage data masking supports mysql and has a free downloadable version.

Check out - http://www.datamasking.com/products/featured-product-downloads

Answer 2

You can anonymize all entries in a MySQL table simply with

UPDATE users SET email = concat('user_', id, '@example.com');

i.e. by using an SQL Update with string expressions. The user with ID 1 gets the email [email protected], the user with ID 10 gets [email protected], etc.