Hi, If you don't care to much how the data look like - just run once of update and replace it with some random stings. If you do however, and you still want to telephone numbers looks like telephone numbers, what I can suggest is to use a data generator like this one http://www.generatedata.com/ and generate sufficient amount of fake data, then run a simple select - update query or script and change data in your database. I was using that a couple of times when a UAT database was restored from production but 'cause of data sensitiveness I had to mask it a bit.
Good luck! m Od: reena.kam...@jktech.com Do: mysql@lists.mysql.com; Wysłane: 8:57 Wtorek 2014-04-15 Temat: Data masking for mysql > Hi, > > I need to do data masking to sensitive data exists in mysql db. is there any > data masking tool available for mysql with linux platform. > if yes... please provide the links. > else... please suggest other alternatives for this requirement. > > I look forward to hearing from you. > > With best regards, > Reena Kamboj > > ********************************************************************************************************************** > > > > CONFIDENTIALITY. This e-mail and any attachments are confidential and may > also be privileged. If you are not the named recipient, please notify the > sender immediately and do not disclose the contents to another person, use it > for any purpose, or store or copy the information in any medium. Any views > expressed in this message are those of the individual sender, except where > the sender specifically states them to be the views of JK Technosoft Ltd. If > you have received this e-mail in error please immediately notify the person > who has sent this email to you with copy to administra...@jktech.com > > ********************************************************************************************************************** > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
