quote:Frankly if your schema is in a regular state of flux and you are not in a development environment then there is something seriously wrong with the design or analysis behind the database. Possibly the DBA has been given the title because it is one he can spell!
quote:You need scripts:- To propogate any new types. To drop any indices on the columns being changed. To drop any DRI using the columns. To apply your extra UDTs or refresh the old ones within the tableTo recreate indicesTo reinstigate DRIIn other words bread and butter DBA stuff.
quote:There has to be a caveat. George Bernard Shaw wrote that the reasonable man attempts to accomodate all changes and find compromises for all situations and therefore all progress is left to the unreasonable man.