Test data generator for MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Test data generator for MySQL

Post 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 :?
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Post 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/
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Post 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 :)).
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

Just write your own, probably would take less time than searching for one.
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Post by aaronhall »

That's what I'm thinking
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Post by nickvd »

Um... You must have missed the link to the downloadable version. :D
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Post 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!
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post 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 !
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post 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.
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Post 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... :(
Post Reply