There are various free data generators to create test or dummy data for a database, but generally speaking, they don't handle foreign keys between tables very well. This video shows how to create random data from a free test data site, manipulate the tables in Excel to maintain foreign keys and other advanced referential integrity logic, and then convert the data to SQL insert statements.
The files referred to and other documentation can be obtained from: http://chitu.okoli.org/psyche/it/crea...