What are the challenges you face when working across database platforms? Take the survey

Matching Columns in Generation

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?


  • Options
    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
Sign In or Register to comment.