Generate data for MySQL tables

Question

Is there a program like Red Gate's Data Generator for MS SQL Server that generates data based on your database schema for MySQL?

Other alternatives (easy) to accomplish the objective very much welcomed!

score 3 · Answer 1 · answered Apr 20 '11 at 10:10

3

Check out benerator:

http://databene.org/databene-benerator

answered Apr 20 '11 at 10:10

score 0 · Answer 2 · answered Feb 18 '14 at 22:48

0

Look at generatedata, which is available via http://www.generatedata.com

You can also fork the project: https://github.com/benkeen/generatedata

It's pretty simple and I didn't need a manual to figure out how to use it.

answered Feb 18 '14 at 22:48

vinnybad

2,102
3
19
29

score 0 · Answer 3 · answered Mar 20 '17 at 00:08

I've written a small script which can generate & populate your DB, it also can execute SQL files. Everything in synchronized manner (important if you have relationships defined in your DB)

Works like a charm for our team.

https://github.com/blacktea/populate-db-now

Generate data for MySQL tables

3 Answers3