Workaround, put a copy of the proc create script in the upgrade script above the changes that require it.
Not sure how to tackle this at highlights a potential tricky interdependency between scripts and procs. The above workaround introduces code duplication which I don't like, however the only other approach I can think of is less elegant - having two sets of scripts, one for pre and one for post proc enforcement.
I'm inclined to mark this as wontfix but will leave it open while I dwell on it for a bit.
Workaround, put a copy of the proc create script in the upgrade script above the changes that require it.
Not sure how to tackle this at highlights a potential tricky interdependency between scripts and procs. The above workaround introduces code duplication which I don't like, however the only other approach I can think of is less elegant - having two sets of scripts, one for pre and one for post proc enforcement.
I'm inclined to mark this as wontfix but will leave it open while I dwell on it for a bit.
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.