Data generation: Test Data: Dummy Data

From: Patrick Lanphier <planphier_at_psu.edu>
Date: Mon, 31 May 1999 13:34:42 -0400
Message-ID: <3752C832.C711F9B6_at_psu.edu>



I would like to generate data for our database, however, I'm running into a couple of problems. None of the tools appear to be satisfactory.

Testbytes:

  1. Doesn't put a semicolon at the end of each insert statement
  2. One can not order the creation of test data to maintain integrity
  3. It's $2,000 PumpItUp:
  4. Can not generate insert statements to a file Datatect:
  5. Can only generate one table at a time.
  6. One can not order the creation of test data to maintain integrity
  7. Can not generate insert statements to a file

What I would like to see is a tool that generates insert statements in the appropriate order to file that I can then version control. With each future change to the database I can then update that tables insert statements and then generate database for the new schema. I would like to find a perl script or something, but have not yet, please help.

Patrick Lanphier
Advanced Information Technologies
The Pennsylvania State University Received on Mon May 31 1999 - 19:34:42 CEST

Original text of this message