Red Gate forums :: View topic - Use Existing Data Source and Foreign Key Fields
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Use Existing Data Source and Foreign Key Fields

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DanielEgleston



Joined: 05 Mar 2010
Posts: 3
Location: Cleveland, OH

PostPosted: Mon Mar 08, 2010 3:59 am    Post subject: Use Existing Data Source and Foreign Key Fields Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Tue Mar 09, 2010 6:51 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group