Red Gate forums :: View topic - Features/Issues
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 1
SQL Data Generator 1 forum

Features/Issues

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
paulh



Joined: 08 Oct 2005
Posts: 33

PostPosted: Fri May 09, 2008 3:58 pm    Post subject: Features/Issues Reply with quote

Following on from other comments, I'd like to add a few more requests...

1. Simpler way of having nulls generated - at the moment the method seems to be use a RegEx and set the null percentage to 100%

2. Similarly for a fixed value, have to use a RegEx rather than just say a FixedValue generator, e.g. setting an integer or bit field

3. Counter generator, takes start number and increment and keeps going - example here is that I have to generate 50K users for a load test - with a RegEx generator I have to dump the file afterwards to find out the usernames I can use; unless someone can suggest a better way?

4. Ignore columns - important, but already mentioned.

5. Dates - ability to push Current Date/Time in

Regards

Paul
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Mon May 12, 2008 10:34 am    Post subject: Reply with quote

Hello Paul,

Thank you for the feedback, it is much appreciated.

1) At the moment, setting a generator to 100% nulls is the only way. We have an item to look at this in a later version.

2) Like in 1, we understand this isn't great at the moment and we are looking at making it more understandable. However, using the other generators, such as RegEx, can provide you with this functionality.

3) On our numeric generators, we have two types of distribution. One is Random, the other is sequential. With sequential, you can set an increment value, this allows you to go 1,2,3,4,5,6,7,8,9 etc. If you look at the Business > IDs generators, you can see how we have used it. Does this answer your question?

4) Thanks, I've added a note onto the item that you have also requested this. It's useful to know where the demand is.

5) Like with 2, it would be more useful to have a generator which could do this. Two possibilities with this, one is write your own generator and upload it to CodePlex to share. The second, use a SQL Statement generator and as the sql statement use SELECT GetDate().

I hope this helps, if you need anything else please let me know.

Thanks

Ben
Back to top
View user's profile Send private message
paulh



Joined: 08 Oct 2005
Posts: 33

PostPosted: Mon May 12, 2008 12:03 pm    Post subject: Reply with quote

Problem with 3. is that my column is not a number, it's a string and what I want is something like

webload00001, webload00002 etc

Also, I can't allocate your Id generator to a string column.
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Mon May 12, 2008 2:26 pm    Post subject: Reply with quote

Hi Paul,

Oh I understand. Yes, this has been mentioned before. At the moment, there isn't a way to do this, apart from creating your own generator. I'll add another note to the system.

Thanks for the additional information.

Ben
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group