Generate data for an application

Question

Hi there

If your planing to build an application but you don't have enough data to fill a database, how you will generate some ?

Do you know any application which can generate data based on some criterias and export it later in MySQL database?

Thanks :)

Answer 1

I always try to fill DB with some real data, related to the subject. So I can see, how the data will be faced to user. Of course, if you want to run performance tests, you should generate some random data.

Answer 2

if you have access to a production db with real data, then look at this Java library to partially export a database while respecting referential integrity constraints