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.