For the Database Programmers of the Group

Author: JediSage
Date: 13-Mar-2006, 9:17 AM

Author: JediSage
Time: 13-Mar-2006 9:17 AM
Post link

Does anyone know of a tool that generates dummy database records for testing purposes? I wrote a db last week and one of the things I find really tedious about it is to generate test records on my own. We want to "stress test" it with about 1000 records and really don't want to sit there and key it in.

If there isn't one out there, would you be interested in a tool like this?

Nemo me impune lacessit

http://ttrim.blogspot.com

Author: Jay
Time: 13-Mar-2006 9:39 AM
Post link

Fortunately, I have a large amount of forum data to draw upon for my testing purposes. I don't know of a tool that generates data though.

How about writing an insert statement and looping through it 1000 times?

Forum Administrator

MTFBWY…A

Author: Zion
Time: 13-Mar-2006 9:45 AM
Post link

Yeah, you could write a function that loops through and inserts random data into each record.

My Projects:
[Holiday Special Hybrid DVD v2]
[X0 Project]
[Backstroke of the West DVD]
[ROTS Theatrical DVD]

Author: JediSage
Time: 13-Mar-2006 11:00 AM
Post link

Hmmmm. Well, the tool I use is DBF compliant, however it's not SQL compliant unless I use ADO controls on my forms. It has it's own proprietary query engine within the DB so I'm not sure a typical SQL insert would work.

You have given me an idea though as there's got to be a similar command in the program itself.

Thx Jay & Zion...

Nemo me impune lacessit

http://ttrim.blogspot.com