Comments
Sort by recent activity
I would find this very useful. Please post! / comments
I would find this very useful. Please post!
+1 bump!
I would really appreciate being able to do this. I would model it similar to the SQL Statement generator, except that the table.column are locked-in by the FK, and all you can do is add a WHERE clause to restrict the population.
Please let me know if that doesn't make sense and I'll try to explain again... / comments
+1 bump!
I would really appreciate being able to do this. I would model it similar to the SQL Statement generator, except that the table.column are locked-in by the FK, and all you can do is add a...
BTW, after doing a search I found another thread about this same issue at: http://www.red-gate.com/MessageBoard/viewtopic.php?t=6867.
I also posted about this when I first review SDG 1 on this thread: http://www.red-gate.com/MessageBoard/viewtopic.php?t=6928 as issue #1.
Right now I'm going to try to work around this by hacking the XML to use the SQL Statement generator for the column.
FYI, this is probably the main reason I did not renew my support contract when it came due. I personally consider it much more useful than SQL2008 support, but that may change in a year... / comments
BTW, after doing a search I found another thread about this same issue at: http://www.red-gate.com/MessageBoard/viewtopic.php?t=6867.
I also posted about this when I first review SDG 1 on this thre...
Not to hijack this request, but it would also be nice to automatically populate a weighted list generator from a foreign key. / comments
Not to hijack this request, but it would also be nice to automatically populate a weighted list generator from a foreign key.
Hi Ben,
benhall wrote:
Thank you very much for all of the feedback! It has been really useful.
Glad to help.
benhall wrote:
4) On the table generation settings, you can define what should happen if the data is invalid - for example too large for the column. I recommend that you switch this to truncate data instead of skip row which will solve your problem without having to modify the regex.
Yes, but that would affect the entire row, correct? Regardless, that's probably a good idea.
benhall wrote:
6) Could you suggest any alternatives on how you would have liked to solve this scenario? Do you think a different type of generator is required for example?
I'd like to be able to specify a constant prefix (maybe, for bonus points, a selection of prefixes with weights) which would then have a number appended to it. The number should have the same options as your current number generator (sequential, random, step size, etc...) with the option to zero-pad it out to a certain length.
This could generate data like:
HMS00001
HMS00002
HMS00003
...
benhall wrote:
12) You can configure this behaviour in the application options, under project setup however I'm not sure this is the best place for the setting.
Never noticed that. However, I would argue that you probably don't need a setting. Just do it once when creating a new project, and then offer to do it when the "refresh schema" button is pressed.
benhall wrote:
13) I am unable to replicate this. Have you configure the generator with any SQL text or connection setting?
No, I don't believe so.
benhall wrote:
16) Could you please confirm which Set unique option you mean? Is is the "All key values unique" option?
Yes. / comments
Hi Ben,
benhall wrote:
Thank you very much for all of the feedback! It has been really useful.
Glad to help.
benhall wrote:
4) On the table generation settings, you can define what should happ...
Lionel wrote:
Also sorry but I did not understand what you mean by.
If I create/save a project, then add tables to the database, then reopen the project, the new tables are automatically selected for generating random data. This is BAD!
I probably am having dificulty as it is 19:52 on a Friday [image] . Do you mean when you add new tables they are selected as part of the generation?
Yes, exactly -- and if you reopen the project that was created before the tables existed in the db, and then click generate without noticing that they were automatically selected, SDG will cheerfully overwrite the data that I placed into the new tables when I created them. [image]
Lionel wrote:
I will try to have a look into some of these issues next week ni a little more depth as some of the issues like number 14 should not happen at all. Have you definatly got the 'Allow null values' checkbox unchecked?
Sorry, wrong generator. I meant the SQL Statement generator. That one doesn't even have a checkbox/percentage for NULLs. / comments
Lionel wrote:
Also sorry but I did not understand what you mean by.
If I create/save a project, then add tables to the database, then reopen the project, the new tables are automatically select...
Just noticed another problem:
16 - When using the Foreign Key Generator on a composite key, the "Set Unique" option is not working properly. We are getting multiple occurrences of the key being generated even though there are more than enough records in the parent table to provide unique tuples for the child table. / comments
Just noticed another problem:
16 - When using the Foreign Key Generator on a composite key, the "Set Unique" option is not working properly. We are getting multiple occurrences of the key being ge...
OK, two more:
14 - We're having a problem with the both the manual and regular Foreign Key Generators inserting NULLs into the referencing table. It's very seldom, doesn't affect every column that uses the generator and only about 1 in 1000 rows gets a NULL when it does, but we've had to add post-generation scripts to clean this up in a few places.
15 - The XML that is generated by SDG in the SQLGEN project files is all on one line. This makes it very unfriendly to deal with using text-based tools such as diff. I have to run it through
sed -re "s/<[A-Za-z]/\n&/g"
to get anything remotely useful. / comments
OK, two more:
14 - We're having a problem with the both the manual and regular Foreign Key Generators inserting NULLs into the referencing table. It's very seldom, doesn't affect every column that...
I just ran into another thing:
If I create/save a project, then add tables to the database, then reopen the project, the new tables are automatically selected for generating random data. This is BAD! [image] / comments
I just ran into another thing:
If I create/save a project, then add tables to the database, then reopen the project, the new tables are automatically selected for generating random data. This is B...
I guess I'm up to 13 now...
13 - After selecting the SQL Statement generator from the dropdown, the application freezes for some non-trivial amount of time (20 seconds or so). My guess is that it's trying to validate the sample text you have in there against proper SQL syntax. / comments
I guess I'm up to 13 now...
13 - After selecting the SQL Statement generator from the dropdown, the application freezes for some non-trivial amount of time (20 seconds or so). My guess is that it'...