For several years MS have
promoted declarative, model-based SQL development with tools like SSDT. At the
same time people like Jez Humble, Dave Farley and Pramod Sadalage promote an
iterative, migration script based approach asserting that update scripts should
be tested early and not generated by tools.

Presenters of “how to do database DevOps”
sessions annoy me when they say one way is good and the other is bad. It depends.

I’ll illustrate the limitations of each approach
with a simple scenario. I’ll describe which projects are better suited to a
model or a migrations approach, and whether it’s possible to get the best of
both worlds.
(no tags)
The video is not available to view online.