Page 1 of 1

Test data generator for MySQL

Posted: Thu Apr 12, 2007 6:06 pm
by aaronhall
Haven't been able to find a good freeware app for Windows -- I'll probably end up writing one in PHP, but wanted to check if any of you know of one. The best I've found is a product called DB Data Generator, but it's restricted to a 30-day trial :?

Posted: Thu Apr 12, 2007 6:29 pm
by nickvd
What keywords did you use for a google search? The first result for "data generator" points me to what I use regularly..

http://www.benjaminkeen.com/software/data_generator/

Posted: Thu Apr 12, 2007 6:46 pm
by aaronhall
Actually, I had been using that (forgot to mention), but they limit output to 200 rows or so, and I'm not real fond of copying and pasting SQL into phpMyAdmin either. "DB Data Generator" connects directly to the database and eliminates the cut and paste work... makes it possible to do hypothetical performance tests on 100,000 row tables (hours of fun :)).

Posted: Thu Apr 12, 2007 6:57 pm
by Benjamin
Just write your own, probably would take less time than searching for one.

Posted: Thu Apr 12, 2007 6:59 pm
by aaronhall
That's what I'm thinking

Posted: Thu Apr 12, 2007 7:02 pm
by nickvd
Um... You must have missed the link to the downloadable version. :D

Posted: Thu Apr 12, 2007 7:10 pm
by aaronhall
nickvd wrote:Um... You must have missed the link to the downloadable version. :D
:banghead: you just saved me a lot of time :D thanks -- I'll just send the output straight to mysql. You rock!

Posted: Fri Apr 13, 2007 1:49 am
by dibyendrah
Cool.... I was looking similar kind of tools for generating data. I used to manually feed the data which used to take lots of time. Thanks !

Posted: Fri Apr 13, 2007 2:42 am
by RobertGonzalez
nickvd, you mind adding that link to the useful posts thread in the Databases forum? Or I can and give you credit. Just thought you like your name on it from yourself.

Posted: Fri Apr 13, 2007 3:20 am
by nickvd
Added... Thanks :) I've had many ideas to modify the script to add more data types. Those that it does come with, while standard and pretty much required, are not enough to satisfy most if not all serious cases...

I just can't seem to find the time... :(