Features/Issues

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Features/Issues

Postby paulh » Fri May 09, 2008 3:58 pm

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
paulh
 
Posts: 33
Joined: Sat Oct 08, 2005 5:28 pm

Postby benhall » Mon May 12, 2008 10:34 am

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
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby paulh » Mon May 12, 2008 12:03 pm

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.
paulh
 
Posts: 33
Joined: Sat Oct 08, 2005 5:28 pm

Postby benhall » Mon May 12, 2008 2:26 pm

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
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests