Matching Columns in Generation

The simplest way to populate your database with test data.

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?
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
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests