3 ms·
SCM solves the easy problem of maintaining the history of the DDL required to build an empty database from scratch (and you can even have DML under source contr
by dpb000 11y ago
SCM solves the easy problem of maintaining the history of the DDL required to build an empty database from scratch (and you can even have DML under source control to populate the database with test data once it is built).
When version 1.2 of a table's DDL adds a new, not nullable column to the version 1.1 definition and there are a billion rows in production, you are looking at a one-off migration event.
- zamalek 11y ago> you are looking at a one-off migration event. Right, and that's where you roll up your sleeves and describe how to upgrade to that new column; just like you'd handle an out-of-date wire format with C++. No matter how you look at it, you'll always have to manually deal with the most complex upgrade scenarios no matter what you are targeting (RDBMS/CPU/car/washing machine). The question remains: why are we doing that all the time?