Red Gate forums :: View topic - Newbie question
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Newbie question

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
joeybagdnts



Joined: 14 Apr 2011
Posts: 6

PostPosted: Thu Apr 14, 2011 6:26 pm    Post subject: Newbie question Reply with quote

Hi

Love your products! Have a question about generating data
I have 3 fields in a table I wish to populate with data

FK to another table --> will use the fk generator generating the value 1 - 20 times (there are at least 5000 rows in the referenced table)
YEAR --> value must be between 0 and 9
AMT

There is a unique contraint on the the combination of the FK and the YEAR fields. I want to generate 5000 rows. When I use the int generator and give it the values between 0 and 9, I will only end up with 10? rows in my table. Is there a way to get Data Generator to generate this?


The results should look similar to :


    BI_ID YR AMT
    10082 0 220
    10083 0 700
    10084 0 555
    10081 0 125
    10085 0 325
    10086 0 425
    10087 0 525
    10088 0 625
    10089 0 333
    10090 0 103
    10096 0 8
    10012 0 0
    10016 0 0
    10081 1 150
    10085 1 350
    10086 1 450
    10087 1 550
    10088 1 650
    10089 1 333
    10090 1 105
    10091 1 1016
    10092 1 1382
    10093 1 529
    10094 1 203
    10095 1 203
    10096 1 8
    10013 1 0
    10012 1 0
    10016 1 0
    10019 1 0
    10082 2 275
    10083 2 700
    10084 2 555
    10081 2 175
    10085 2 375
    10086 2 475
    10087 2 575
    10088 2 675
    10089 2 333
    10090 2 107
    10091 2 1368
    10092 2 1856
    10093 2 635
    10094 2 196
    10095 2 195
    10096 2 25
    10100 2 2
    10101 2 0
    10082 3 275
    10083 3 700
    10084 3 555
    10081 3 175
    10085 3 375
    10086 3 475
    10087 3 575
    10088 3 675
    10089 3 333
    10090 3 107
    10091 3 1468
    10092 3 1956
    10093 3 735
    10094 3 296
    10095 3 295
    10096 3 8
    10097 3 105
    10098 3 100
    10100 3 2
    10001 3 0
    10321 3 0
    10322 3 0
    10082 4 250
    10083 4 700
    10084 4 555
    10081 4 150
    10085 4 350
    10086 4 450
    10087 4 550
    10088 4 650
    10016 4 0
    10019 4 0
    10020 4 0
    10082 5 220
    10083 5 700
    10084 5 555
    10081 5 125
    10085 5 325
    10092 5 789
    10093 5 342
    10094 5 184
    10095 5 132
    10096 5 8
    10012 5 0
    10016 5 0
    10019 5 0
    10325 5 0
    10321 5 0
    10322 5 0
    10081 6 100
    10085 6 300
    10086 6 400
    10087 6 500
    10088 6 600
    10089 6 333
    10090 6 101
    10091 6 423
    10092 6 549
    10096 7 0
    10012 7 0
    10322 7 0
    10020 8 0
    10313 8 0
    10316 8 0
    10315 8 0
    10317 8 0
    10321 8 0
    10322 8 0
    10321 9 0
    10322 9 0
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Apr 18, 2011 3:08 pm    Post subject: Reply with quote

I've had a little play around with this and sort of got it to work - for my FK column it's set to repeat the values between 1 and 10 times (I have 5000 rows in the related table, and I'm wanting to generate 1000 rows for the table in question).
For the YR column it's set to INT, min value of 0, max of 9, and "Set Unique" OFF. The Distribution is "Sequential".

This generates 1000 rows with each BI_ID repeated while the YR goes up 0 > 9, then it moves on to the next BI_ID value and so on.

I wasn't sure you could get it to do it more randomly, but as a quick test, I changed the FK option to repeat key values at random, and it still seemed to generate 1000 rows OK.

If you're still having trouble, perhaps you could post (or mail to support with F006889 in the subject line) a create script for the table (along with the related ones) and I can look into it a little more.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group