Data entegrity /Data Masking

jemacc

I will like to create a custom data masking which apply the same masking to a column . for example, to keep data entegrity and consistence column_1 = (masked) 12345x. for all the columns with this name and value will be the same across all same columns in other tables. to get consistence relational structure.

Jessica R

Hi there,

I can't think of an easy way to do this unfortunately- the problem is that when using an existing source, SQL Data Generator randomly grabs the data from the source to insert into the target. I'm not a developer myself so I don't know exactly how to do it, but a Python script may help, depending on your setup: https://documentation.red-gate.com/display/SDG3/Generic+generators#Genericgenerators-Pythonscriptgenerator