• Jason Whitish (8/1/2014)


    We're in the middle of a huge project that's migrating an old legacy database into the current model, and we're using this strategy heavily, along with instead of triggers on the views. It's been very helpful in letting us make the changes iteratively, especially since there can be literally hundreds of objects in the database that reference a given table in some fashion.

    There are some serious challenges though, and performance is sometimes one of them. There's no way we could do these changes all in one release cycle though, that way would lie madness and destruction.

    This would be interesting to plenty of people. If you had a particular table or two and are interested, we'd love an article or two on your experiences.