Automatically generate sql insert statement with d

问题:

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

回答1:

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

回答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.

回答3:

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

回答4:

This looks like very unique requirement of data generation but this answer might help.

quickest-way-to-fill-sql-table-with-dummy-data