DbUp and script directory

Question

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?

Answer 1

DbUp automatically takes the filenames in alphnumeric order, so prefix them with a version or timestamp.

Answer 2

DbUp takes the path into consideration and stores it in SchemaVersions. You organize exactly as you have asked the question.