This sounds like something Sqitch would help with.
Last I used sqitch, it returned a zero value on error, which made me leery of using it for scripted deployments.
I have been looking for a tool that will allow me to track, diff and revert changes to the content of specific "business logic" tables so that we can acurately track and test those changes.
It doesn't look like anything like that exists, so eventually I'll have to roll my own.