The simplest way to populate your database with test data.
Moderators: David Atkinson, Anu Deshpande, Lionel
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?
- Posts: 3
- Joined: Fri Mar 05, 2010 7:56 pm
- Location: Cleveland, OH
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?
- Posts: 6668
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Data Generator 1
Who is online
Users browsing this forum: No registered users and 1 guest