October 21, 2009 at 4:36 am
Hi
Quick example of what I am talking about:
- alter an indexed view
if this view is depended on by other views, functions, stored procedures etc.
they may also need to rebuilt - and their dependent objects also etc.
if the change is made on a production server the whole thing needs to be done
in a transaction to keep things consistent
In other words, making a small change to single object *properly* can be complex
and at minimum requires calculating a dependency tree
To further complicate this - the typical? approach of maintaining a set of "alter" scripts
for views, triggers, procedures, etc. does not work
October 22, 2009 at 8:18 pm
Check out RedGate's toolset. They've got some really amazing stuff. I can't say whether or not it will perfectly suit your needs, but it's definitely worth looking at. SQL Compare does a lot of this, not sure if it catches it all or not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply