State vs Migration for Database Source Control: Decide Based on One Question
Category:
devops-automation
One controversial topic in database development is how to properly store and deploy database changes.
This is generally described as choosing between two options, which are approximately as easy to understand as Greek philosophy:
- State based: A Platonic view of the database as a snapshot of a set of forms in a given state at a point in time
- Migrations: An Aristotelian view of the database defined as a series of scripts which generate change over time
