User profile for Lionel

I should add that we will be shipping a 1.1 version probably sometime next week that will fix issues 1 and 9. 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! Smile 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? 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? Lionel / comments

I should add that we will be shipping a 1.1 version probably sometime next week that will fix issues 1 and 9. Also sorry but I did not understand what you mean by. If I create/save a project, then...

0 votes

Thanks a lot for the feedback. I will get thouse entered into our bug tracking system and hopefully we will be able to get a whole lot of them fixed. If you find any other problems them please add them to the list. Again thanks a lot for reporting all thouse issues. It really helps us know what things to work on next in the product. Lionel / comments

Thanks a lot for the feedback. I will get thouse entered into our bug tracking system and hopefully we will be able to get a whole lot of them fixed. If you find any other problems them please add ...

0 votes

Sorry for taking so long to get back to you. In version 1.0 we have added an extra feature to SQL Data Generator that makes this situation work a bit better. What happend is if you have a unique constraint across several columns we detect that each of the columns do not have to be unique so we restart the generators. I will try to explain this a bit better but it is very hard to explain without a piece of paper [image] . Feel free to skip this bit if you just want the fix for your problem [image] . If we have a generator that gives the values (a,b,c) and another generator that produces the values (1,2) and we have a unique constraint across two columns in the beta the follwoing would have happened Col1 Col2 a 1 b 2 Then the generator on Col2 will run out of values so we only generate 2 values which is clearly incorrect as we can generate 6 values. So in the released version we detect that we can repeat the values in the generator as long as you do not get two rows the sames. I will not explain the algorithm here as it is not very interesting but what you should end up with in SDG version 1.0 is. Col1 Col2 a 1 b 2 c 1 a 2 b 1 c 2 Which will give you all the possible values. So why is this not working for you. Well there is a bug in the current version (1.0) where it is not detecting that it can do the column restarts correctly. I will email you a patch that fixes this bug and if anyone else has this problem then please send me an email and I will give you the patch. It will be fixed in the next patch release. One important point to add is that all the generators that are assigned to columns that are part of the unique constraint must be set to "All Key Values are Unique" or the columns will not get restarted. Now as you have noticed the skip rows feature does not detect duplicates and skip them. Unfortinatly we chouse a very poor name for this feature. This feature infact only detects when values are the wrong type or too wide from a column and skips thouse rows. I will definatly look at extending this feature to skip duplicate rows too I agree that it would make sense if it skipped rows that violated constraints were duplicate rows too. So sorry for our very poor naming of this feature. As a work around you can use the IGNORE_DUP_KEY when createing unqiue index and then the duplicate rows that SQL Data Generator produces will just silently get dropped and not stop the generation. It is a bit of a nasty hack but will work. I hope that clarifies everything but if you have any more questions please ask as I do not think that was my best explanation ever. Lionel / comments

Sorry for taking so long to get back to you. In version 1.0 we have added an extra feature to SQL Data Generator that makes this situation work a bit better. What happend is if you have a unique co...

0 votes

I think ben actually meant to write R:\_Temp\zempa\Redesign\TestData>"C:\Program Files\Red Gate\SQL Data Generator 1\SQLDataGenerator" /project:R:\_Temp\zempa\Redesign\TestData\test.sqlgen / comments

I think ben actually meant to write R:\_Temp\zempa\Redesign\TestData>"C:\Program Files\Red Gate\SQL Data Generator 1\SQLDataGenerator" /project:R:\_Temp\zempa\Redesign\TestData\test.sqlgen

0 votes

Thanks a lot. I have found the problem and have emailed you a fix. If anyone else has this problem then please email support@red-gate.com and they will give you a patch. The fix will apear in SQL Data Generator 1.1. Lionel / comments

Thanks a lot. I have found the problem and have emailed you a fix. If anyone else has this problem then please email support@red-gate.com and they will give you a patch. The fix will apear in SQL D...

0 votes

I will send you an email with a way of getting more debug information so we can get to the bottom of this. Just so I know which version of SQL Server are you using? Lionel / comments

I will send you an email with a way of getting more debug information so we can get to the bottom of this. Just so I know which version of SQL Server are you using? Lionel

0 votes

Hi it sounds like the user that you are connecting with does not have sufficent permissons. SQL Data Generator uses the Same object model as SQL Compare so will need the permissions as are suggested in this knowledge article https://www.red-gate.com/support/kb/KB200707000072.htm If having more permissions doesn't fix the problem then please let me know and I will suggest something new. I will add a bug to our bug tracking system that we should give a much better error message in that area as that message is awful! Lionel / comments

Hi it sounds like the user that you are connecting with does not have sufficent permissons. SQL Data Generator uses the Same object model as SQL Compare so will need the permissions as are suggeste...

0 votes

Thanks a lot for the feedback. Both those feature seem like excellent ideas. We have some ideas about how to do the distribution feature but I am really interested in how you would like it to work. Would you like to be able to choose from a variaty of existing distributions and specify the params say choose a normal distribution and change the min, max, variance and average values or would you prefer to be able to define your own curve? Also would you like to make the distribution as the distribution of some data in an existing column? Being able to choose a generator based on a columns value is another feature that a few people have asked for. Would you like to have some GUI where you say use a particular generator if a column was one value and another generator if it was another value? Would you rather we had some simple little expression language based around SQL so you could specify the value based using case statement? By the way of you vist the codeplex site http://www.codeplex.com/SDGGenerators We have made some UK address generators available for download which you might find useful. Sorry for all the questions and thanks again for the feedback. Lionel / comments

Thanks a lot for the feedback. Both those feature seem like excellent ideas. We have some ideas about how to do the distribution feature but I am really interested in how you would like it to work....

0 votes

We are looking for feedback about version 1.0

First I would like to thank all the people who provided feedback on the SQL Data Generator Beta. It really helped us a huge amount in producing the product. We still looking to improve the product ...

8 followers 10 comments 0 votes

Thanks a lot! I will forward that along to the developer who is responsible for the engine to see if he has any insight as to what is going on. Lionel / comments

Thanks a lot! I will forward that along to the developer who is responsible for the engine to see if he has any insight as to what is going on. Lionel

0 votes

How can we help you today?

Lionel

Activity overview