Quote:
Originally Posted by Soap-dodger
However, what is lacking here is simply the ability to add columns to the Authors table, which is a core DBMS function, surely.
|
Adding a column to a DBMS schema is easy enough, but new columns will often create the need to add new indices, views, triggers, foreign keys etc.
Propagating the changes across multiple database instances is difficult in the best of circumstances - e.g. within a corporate branch structure. But it is orders of magnitude more difficult when there are millions of them, over which the developers have very limited control, no access, nor knowledge of the plethora of backup regimes in play.
BR