Activity overview
Latest activity by jrichardson
1. For your nullable foreign key you could select the tickbox "Allow null Values" (under Generator settings) and then the approximate percentage that you wish to be null.
If I have a FK on a column, the "Allow null values" checkbox is grayed out.
2. Under the Generator settings you could modify the population method to "repeat key values between x and y".
I have tried this, e.g. repeat key values between 1 and 10, or repeat key values between 10 and 10, for 10 new records, and it doesn't work. / comments
1. For your nullable foreign key you could select the tickbox "Allow null Values" (under Generator settings) and then the approximate percentage that you wish to be null.
If I have a FK on a column...
Foreign key generators and dependent fields
I'm attempting to use SQL Data Generator to generate some test data for a project but I'm having a few problems.
* If a field has a foreign key, but is marked as nullable, it seems I still need to ...
No indicator in SSMS when static data has changed
I'm not sure if this is a bug or a missing feature.
I have a database linked to source control (SVN) with a table linked for static data source control. When I make changes to the static data for t...