- The state-driven approach is good for projects with a lot of logic in the database and a large team working on it. You are also better off choosing it for small projects that are not in production yet.
- The migration-driven approach is a better choice in all other cases
Summary Article:
http://enterprisecraftsmanship.com/2015/08/10/database-versioning-best-practices/
State based vs Migration based DB delivery
http://enterprisecraftsmanship.com/2015/08/18/state-vs-migration-driven-database-delivery/
DB Delivery Training course: (2h 15min)
https://app.pluralsight.com/courses/database-delivery-best-practices