Pages Menu
Chitu Okoli chitu.okoli.org

Posted on Dec 1, 2015 in Computers and the Internet

Create test data for a database with foreign keys

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.

Read More