Generate data for MySQL tables
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!
Check out benerator:
http://databene.org/databene-benerator
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.
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
精彩评论