Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Folder/FilenameCommit Time

ddl/alpha.sql
ddl/beta.sql
ddl_direct/beta2.sql
sql_direct/eddy.sql
sql_direct/epsilon.sql
view/delta.sql

21:00
ddl/barney.sql22:00

...

DEFAULTALPHANUMERIC
  1. ddl/alpha.sql
  2. ddl/beta.sql
  3. ddl_direct/beta2.sql
  4. view/delta.sql
  5. sql_direct/eddy.sql
  6. sql_direct/epsilon.sql
  7. ddl/barney.sql
  1. ddl/alpha.sql
  2. ddl/barney.sql
  3. ddl/beta.sql
  4. ddl_direct/beta2.sql
  5. sql_direct/eddy.sql
  6. sql_direct/epsilon.sql
  7. view/delta.sql

Notes

  • Two commit times: ddl/barney.sql is packaged last
  • Fixed folder order: ddl, ddl_direct, view, sql_direct
  • Alphanumeric within each folder

Notes

  • Commit time is not considered, so ddl/barney.sql is packaged earlier in the sequence
  • Folder+filename order is strictly alphabetical, so view/delta.sql is packaged later in the sequence

...

  • There are a large number of teams, each with a smaller area of specialization 
  • The team commits SQL scripts less frequently or at irregular intervals.
  • Teams are organized according to different types of SQL changes: DDL, DML DML, individual stored-logic types.  

...