I'm using DbUp, starting from the example I've created a C# program. The example suggest me to put all scripts under Scripts directory. Ok, this is done but, when script number will grow up that directory will be such a big mess.
I would organize that directories with version number. For instance
- 1.0.0 (directory)
- CS001 - baseline.sql
- 1.0.1 (directory)
- CS001 - alter x table.sql
- CS002 - create y procedure.sql
- 1.1.0 (directory)
- CS001 - create view z.sql
Obviously, code would take the script in an ordered manner. How can I do that? Where I found documentation and other examples?