Related primary Keys the way I want

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Related primary Keys the way I want

Postby omacall » Tue Nov 02, 2010 5:32 pm

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
 
Posts: 1
Joined: Tue Nov 02, 2010 4:26 pm

Postby chriskelly » Wed Nov 03, 2010 6:59 pm

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
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests