Red Gate forums :: View topic - Related primary Keys the way I want
Return to RSS Feed Available

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

Related primary Keys the way I want

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

Joined: 02 Nov 2010
Posts: 1

PostPosted: Tue Nov 02, 2010 5:32 pm    Post subject: Related primary Keys the way I want Reply with quote

Hello. I was trying out your awesome Product to generate data .

and I think is great,

after doing my homework and reading how to generate customized data for my applications, I still have the following questions

1- How to generate the relational Foreign key, for example in a Invoice table, if I want to generate the FK Customer ID to be 1 for 10 Invoices, the options I have only generate random keys or all fixed. but how can I do the sets of 10 s.

2- if I need to change the integers vales that are generated to a more realistic value of only positive number from 1 to 2000 lets say. but not having to go into each field to set the value (winch is crazy when many tables are involved) just do it globally for all integers.

3-is there a way to tweak the global settings a bit more instead of having to set each individual value for each field one by one.

RedGate does it again.. great performance with a marvelous product. I am telling all my friends about it

BTW: these are the same files that are included with the product right ?
Back to top
View user's profile Send private message

Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Wed Nov 03, 2010 6:59 pm    Post subject: Reply with quote

Thank you for your post.

1. When you are generating data for a Foreign Key, look under Population Method, where you can select "Repeat key values between X and Y times". Here you can select any number between 1 and 100. So in you case select between 10 and 10 times.

2. Unfortunately there currently isn't a way to apply settings to all of a particular type of column. I have raised a Feature Request (SDG-917) to include this type of functionality in a future version.

3. Again this isn't possible. This may also be included in a future version of the tool.

(If you are refering to the Help files, then yes these are the same. However, there are more resources available on the webpage)
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