Test data generator for MySQL
Moderator: General Moderators
- 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
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:
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/
http://www.benjaminkeen.com/software/data_generator/
- aaronhall
- DevNet Resident
- Posts: 1040
- Joined: Tue Aug 13, 2002 5:10 pm
- Location: Back in Phoenix, missing the microbrews
- Contact:
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
).
-
nickvd
- DevNet Resident
- Posts: 1027
- Joined: Thu Mar 10, 2005 5:27 pm
- Location: Southern Ontario
- Contact:
Um... You must have missed the link to the downloadable version. 
- aaronhall
- DevNet Resident
- Posts: 1040
- Joined: Tue Aug 13, 2002 5:10 pm
- Location: Back in Phoenix, missing the microbrews
- Contact:
nickvd wrote:Um... You must have missed the link to the downloadable version.
- dibyendrah
- Forum Contributor
- Posts: 491
- Joined: Wed Oct 19, 2005 5:14 am
- Location: Nepal
- Contact:
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA