Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Execution Order of SQL Change Scripts
-
Is it possible to know and/or control the order in which SQL change scripts will execute during a promotion? I don't see any way to control the execution order. Do they always execute in the order they are listed on applications/{#}/change-scripts? If so, is that order determined by the order in which they are uploaded?
As a workaround, we are including all our SQL scripts in one big script, but we would like to be able to sequence multiple scripts arbitrarily (e.g., by drag and drop ordering in the list).
Product: BuildMaster
Version: 4.1.5
-
It's alphabetical.
We've considered adding in a sequence, but have found that most folks will prefer the old "GWBasic" route of prepending an integer to the name to determine execution order.
- First SCript
- Second Script
- Last script
This ordering comes after the release ordering.