In addition to what Eric said, if you use a case tool like xCase or ErWin they will generate change scripts for you.

BOb


>maintains a target database to be updated to the current state of another source db?
>
>and handles the following:
>
>1)Check a source table to see if a table exists in target database, if it isn’t add it.
>2)In each table check to see if the column/field exists, and if not add it.
>3)Compare the column properties of the source against the installed version, and if there were changes, alter the destination.
>4)Clear and refresh all the stored procedures
>
>TIA