Check http://www.red-gate.com/sql/summary.htm. They have a product to do it.


>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