Data Generating Template using SQL Inserts

[dnparsons]

I've added a Template and Template Archive called DNP Data Generator. Below is an excerpt from DataGenerator.txt.

I got tired of entering test data in an MSDE database
that I created (boring....) So I wrote a template to do
it for me (not boring!)

The template generates SQL insert statements.
The output is randomly generated, semi-realistic data
based on pre-defined key/value pairs entered into
User MetaData. You select a database, a table, and the number
of records to generate.

I've only used it on MSDE 2000, so I'm not sure what
SQL syntax changes would need to be made for other databases.
The dgType Lookup may also be affected.

See NWindGeneratorSamples.zip in the DNP Data Generator Template
Archive for example User MetaData and SQL output.

Any comments, constructive criticism, or bug reports are welcome.