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