Data Redaction

Alex Pixley · July 18, 2014 9:37AM

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 · July 21, 2014 9:17AM

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 .

Data Redaction

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk