Matching Columns in Generation

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Matching Columns in Generation

Postby MasterCephus » Thu Jun 20, 2013 6:08 pm

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:

* ProductID
* ProductDescription

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?
MasterCephus
 
Posts: 29
Joined: Wed Sep 24, 2008 1:56 pm

Postby Manfred.Castro » Fri Jun 21, 2013 7:13 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.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
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