Automatically generate sql insert statement with dummy data

sql database insert dummy-data
Omri picture Omri · Aug 25, 2010 · Viewed 32.5k times · Source

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

pleasedontbelong picture pleasedontbelong · Aug 25, 2010

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

Related questions

Solutions for INSERT OR UPDATE on SQL Server

Assume a table structure of MyTable(KEY, datafield1, datafield2...). Often I want to either update an existing record, or insert a new record if it doesn't exist. Essentially: IF (key exists) run update command ELSE run insert command What's the …

Read More
How to do a batch insert in MySQL

I have 1-many number of records that need to be entered into a table. What is the best way to do this in a query? Should I just make a loop and insert one record per iteration? Or is there …

Read More
Bulk/batch update/upsert in PostgreSQL

I'm writing a Django-ORM enchancement that attempts to cache models and postpone model saving until the end of the transaction. It's all almost done, however I came across an unexpected difficulty in SQL syntax. I'm not much of a DBA, …

Read More