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?

thanks

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

http://www.red-gate.com/products/sql-development/sql-data-generator/

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.