I've been searching in StackOverflow, however i only got to date this site http://www.generatedata.com/#generator

however it does not support foreign constraints.

can there be any software which could full fill a database having a plenty of tables?

or the only method is writing my very own script?


Take a look at SQL Data Generator from Red-colored Gate:


The characteristics page lists:

  • Foreign key support for producing consistent data across multiple tables

Not quite what you are searching for, but DBUnit may be used to generate significant test data.