How can we help you today? How can we help you today?

Related primary Keys the way I want

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 ?
http://www.codeplex.com/SDGGenerators
omacall
0

Comments

1 comment

  • chriskelly
    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)
    chriskelly
    0

Add comment

Please sign in to leave a comment.