CODEWITHSUNDEEP
sqldatabasetesting
Yichz
Yichz

Reputation: 9681

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

but 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

Upvotes: 1

Views: 152

Answers (2)

anon
anon

Reputation: 1061

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

Upvotes: 0

BigJoe714
BigJoe714

Reputation: 6912

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

Upvotes: 1

Related Questions