I'd like to strip my development database of addresses, emails and phone numbers.
I have a list of personally identifiable information in my DB tables (organized by table and field) I'd like randomized. I need someone to write a script to perform this randomization.
The script can be written in any of the following
* mysql only
* php ezSQL with the PDO or mysqli extension
* wordpress WPDB
To perform this project I'll send you the database DDL and identify the tables. You won't get a chance to work with any of the data. I'll snapshot my development data and run the script for you to test it. I would expect you'd at least load the DDL into an empty mysql database and test your queries to make sure that they run without syntax errors on the empty DB.
Performance won't be an issue. If the script takes a few minutes to run that's fine. Assume all tables have less than 1M rows.
Less than 30 hrs/week
Less than 1 month< 1 monthProject LengthDuration
I am looking for freelancers with the lowest rates