The simplest way to populate your database with test data.
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr
I need to generate data for a table and the situation exists where two fields are dependent on each other. For example, say I have two fields:
and I have a reference table with all of the data. I can generate data for each column independently using the SQL option, but I really need to make them dependent on each other. Like if the generator selects productID 4, the ProductDescription needs to be the correct description...
Any way to do this?
- Posts: 29
- Joined: Wed Sep 24, 2008 1:56 pm
Unfortunately it is not currently possible to generate data based on data that has been/will be generated in another table/column.
There is an existing feature request for this capability with reference number SDG-682.
I have added your details to the existing request.
Red Gate Software
- Posts: 209
- Joined: Mon Apr 23, 2012 2:49 pm
Return to SQL Data Generator 2
Who is online
Users browsing this forum: No registered users and 0 guests