schemachange
schemachange copied to clipboard
Option to change order of execution for scripts
In our development process we currently face the issue from time to time that in a versioned script (V) we are referencing a view or stored procedure that is introduced or updated in the same change via a repeatable script. But since versioned scripts always run before repeatable scripts we need to include the new view / stored procedure definition also in the versioned script. This should be avoided since it's error prone and contradicts the DRY principle. I'm proposing to make this configurable in schemachange by i.e. adding a certain string in the V script name like "post_deploy__" that enables a different order of execution for that specific script.