clean rebuild process?

hello.

i am trying to develop a relatively clean process for creating/populating a
new database.  i have all of the table creation scripts and am about to
start writing scripts to populate the db with the necessary default data (an
admin user, a guest user, default application info, default preferences, etc
etc etc).  is there any easy way to do this?

my current approach is to write a bunch of insert statements in a text
editor.  i can do this, but it's error prone (or i guess i am).  obviously
if i already have a source db i can do some table copying, but i would like
to make this work for a fresh install on a new machine.

is there a better way?

the limit of my imaginatin is this - some sort of command/utility that
queries a table and generates the insert statements from the results.  then
i wouldn't have to worry about updating my default data scripts everytime
data changes.

i appreciate your help/suggestions.

chris