views:

54

answers:

3

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?

A: 

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

Bach
A: 

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:

Jailer export

krock
My requirement is to populate the database tables with dummy values and not exporting the data. I am not sure, if the feature is available with Jailer
Ram
+2  A: 

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.

Mike
This is similar to what I have been looking for. I was thinking about a tool that would read the schema automatically and generate the data values for the tables. But I can live with this. Great tool. Thanks Mike
Ram