> > The concerns of the deltas getting to be too much is simply solved when you > get to that point. In practice the time it takes to run a bunch of deltas to > create a DB from scratch is not much slower than the monolithic file because > DDL runs real fast on an empty DB. >
We can also always roll up the deltas on every big release. Another way would be generate create-schema.sql by snapshotting the delta rollups. The main point is the upgrades and create-schema should be from the same schema so they don't have little deltas that causes bugs. --Alex