Any freeware or open source tool to populate database with some dummy values

Question

I have somewhere around 30 tables used in my web application. I need to populate those tables with some dummy values during development. Later once the application is ready we will have the real data. Are there any tools to populate database tables in MySQL with dummy values?

Answer 1

you could use SQLyog to easily manage your database. The community edition is free.

Answer 2

With Jailer you can export data to an SQL script which can traverse foreign key constraints to include all data needed to maintain referential integrity.

Here is a screenshot from the Jailer website demonstrating the data export:

Answer 3

You could try this:

http://www.generatedata.com/

I've been meaning to look at it for a while, but never quite got round to it.