any way to populate random datas into a data base for testing purpose?

I have been searching in StackOverflow, but I only got so far this website http://www.generatedata.com/#generator

bu开发者_JS百科t it doesn't support foreign constraints.

is there any software which can full fill a database with a lots of tables?

or the only way is writing my own script?

thanks

Check out SQL Data Generator from Red Gate:

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

The features page lists:

• Foreign key support for generating consistent data across multiple tables

Not exactly what you're looking for, but DBUnit can be used to generate meaningful test data.