Use Existing Data Source and Foreign Key Fields

[DanielEgleston]

I want to obfuscate a customer table by generating the address, e-mail, and phone number fields. I want all other fields to remain the same.

I followed the instructions in the published article to use a copy of the database and to use the copy as an existing data source. I modified the fields that I wanted to obfuscate. However, for fields with a foreign key reference, the tool uses the foreign key generator instead of using the data in the existing source, with no ability to change the generator. I don't know why I can't select the column from the existing data source as an option for populating the field. Why is the foreign key generator the only option for fields with a foreign key reference?

[Brian Donahue]

SQL Data Generator does force you to use the foreign key generator when a column has a relationship in another table, so I think you are stuck there. Can you drop the FK temporarily, do what you need, and put it back?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521