Views, Tables and Stored Procedures should be scripted in order of dependency
script creator should be better aware of dependencies such that creating/altering a view or stored proc only occurs AFTER the underlying table has been updated to include the new dependencies. Currently the differences are scripted properly but just not always in order
29
votes
Leon McCalla
shared this idea
This should be happening already – if you have a specific example of it going wrong, can you send email to support@red-gate.com detailing what’s happening?
We know there are still a few cases out there where it doesn’t quite go right, but we’re trying to stamp them out where we find them!
-
Leon McCalla
commented
Views, Tables and Stored Procedures should be scripted in order of dependency