Fork me on GitHub
#sql
<
2018-03-02
>
bja07:03:42

I haven't wanted to declaratively evolve a model and get it to reflect some delta as SQL DDL in a very long time

bja07:03:05

mostly because evolutions to my DDL often involve a complex migration from an operations perspective

bja07:03:46

and the most straight-forward way of accomplishing something (say adding a column) isn't necessarily how it ends up being accomplished

bja07:03:46

I suppose one thing that I could use is a utility to interrogate my database for its current ddl and then to execute all of my migrations against a test db and verify the ddl is the same

bja07:03:52

i.e. we haven't drifted somehow

bja07:03:40

(for instance, due to a rogue dev who decided to do a "fix" directly against the prod db)

bja07:03:32

I might write that utility tomorrow morning, now I'm kinda curious about a particular db at my company