In my experience, these tools never handle complex migrations well. Renaming a column? You might drop the production data, and add a column initialized to its

In my experience, these tools never handle complex migrations well. Renaming a column? You might drop the production data, and add a column initialized to its defaults. My approach is to maintain a stack of diffs to the schema in DDL that are hand-crafted and checked into source control, so that when it inevitably fails during QA there isn't a 2MB SQL diff to hunt through to figure out why.