For initial development of a new system (where the database is new too), you can just create the CI database from scratch, however, in my experience the database scripts for each CI build needs to work on the assumption that the database to upgrade is the last live release. Of course this gets more complicated when targeting upgrading from different released versions of the database.

Preserving and upgrading data is a far more complicated scenario...over to the DBAs!!!