Quickest way to fill SQL Table with Dummy Data

Question

What is the quickest way to fill a SQL table with dummy data?

I have a wide table with about 40 fields of different kinds (int, bit, varchar, etc.) and need to do some performance testing. I'm using SQL Server 2008.

Thank you!

Answer 1

SQL Data Generator by RedGate

Data generation in one click

Realistic data based on column and table name

Data can be customized if desired

Eliminates hours of tedious work

Full support for SQL Server 2008

Answer 2

DB Data Generator can be used to quickly generate test data.