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

can SQL DG calculate a column value?

icecurtainicecurtain Posts: 15
edited December 23, 2011 4:56AM in SQL Data Generator Previous Versions
Just evaluting SQL data generator and if anyone can tell me if this is possible.
Circa 10,000,000 row need to be created.

COL A (Qty) = Random number 1-50
COL B (Qty_Delivered) must be lower than COL A
COL C (Qty_Outstanding) = A-B
COL D (Inv Total Price) = A*E
COL E (Price)= Random cost £1.00-£500.00

Col A and E are easy to produce.
Do I need to create a temp table or can this be done by script?

Comments

  • Options
    Hi there,

    Thanks for your post. Unfortunately, it isn't possible to populate data for columns based on the sum of other columns, i.e. dictate a column relationship other than PK > FK.

    We do however have this as an existing feature request in place of which I will add your request to, however I sorry to say that we don't have a timescale at the moment for if / when this feature is likely be implemented.

    HTH!

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • Options
    Thanks for the reply. I would definitely like it as a new feature!
  • Options
    Hello,
    It actually IS possible - you need to add a script creating trigger ON INSERT before the data generation. To do this Edit project and open Scripts tab.
    Inside the Dilbert's world
Sign In or Register to comment.