Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahevans
Starting Member
1 Post |
 Posted - 2008-02-20 : 04:27:41
|
| hi, we want to provide copies of our databases to a third party but our databases contain sensitive information.We would like to use a tool that would allow us to select which tables and columns within the table we would like to anonymize by replacing existing data with random data.The key thing we would also like to do is to retain format and the length of values after the data has been anonymized eg if the value was a postcode such as nw3 6ty then the anonymized version would still have the space with two sets of three characters where numbers are replaced with other numbers and letters with other letters.Any recommendations on how this could be achieved would be greatly appreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-20 : 04:42:02
|
| Do you want to scramble the data and provide it to users or hide them off? |
 |
|
|
|
|
|
anonymize data