Automatically generate sql insert statement with dummy data

Question

Possible Duplicate:
Quickest way to fill SQL Table with Dummy Data

I'm looking for a tool that will generate insert statement for an existing database filled with dummy data.
This is meant to allow testing of the system.

I'm thinking about something that reads the type of each field and generates data accordingly. If the field name is "username" for example, it's best if it actually knows to take common user names. It should obviously also keep database relations with foreign key constraints.

This doesn't seem too difficult to write this. Is there anything ready which I can use?

Thanks, Omri

Solution 1

i use this one http://www.generatedata.com/ and its free :)

Solution 2

Checkout http://www.generatedata.com/ its a gpl tool to do stuff like that. Most people write scripts that do it because its really hard to account for all the constraints and setup of database tables.

Solution 3

Check out Red Gate's SQL Data Generator - not free, but is ready to do what you want.