Help on Oracle Test Data

From: Scott E. Stratton <infinity_at_supernet.net>
Date: 1997/04/07
Message-ID: <01bc4381$728b3860$42192cc7@supernet.net.supernet>#1/1

Hi!

I am looking for a good tool to generate reasonable test data in an oracle 7.x database. I have looked at a few and the major feature that seems to be lacking is the ability to generate _relational_ test data. In other words, if the tool generates 1000 records in a parent table, then a child table could have between (for example) 1000-5000 records, appropriate linked via the foriegn key (1-5 children per parent). Does anyone know of such a tool? Some other nice features (which some tools do seem to have): psuedo-random data, "real-word" strings, data produced by distribution, GUI interface.

Any thoughts? All discussion much appreciated.

Scott E. Stratton
Senior Software Engineer
Infinity Software Development, Inc. Received on Mon Apr 07 1997 - 00:00:00 CDT