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:

Here is the ERD modeled in the video:

TestDataERD

Here are the links and documents presented in the video, with comments:

Discover more from Chitu Okoli

Subscribe now to keep reading and get access to the full archive.

Continue reading