Automatically generate sql insert statement with dummy data [duplicate]

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

Answer 1

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