Data Redaction

Alex Pixley

I am looking for a way to replace the contents of a single column (SSN data) while leaving the other columns in the table intact. I had heard that this was possible with SQL Data Generator, but I can't figure out how to do it. Am I missing something or does SDG not offer this functionality?

Brian Donahue

In a roundabout way, you can do this. You basically need a copy of the database and set the data for the columns you want to keep to be a SQL query.

Please see http://documentation.red-gate.com/displ ... ata+source .