incubator-cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Darren Shepherd" <dar...@godaddy.com>
Subject schema maintenance
Date Tue, 14 Aug 2012 00:06:47 GMT
Has there been any talk about not maintaining a monolithic
create_schema.sql and doing a more DB migrate style?  From a
supportability perspective its way easier if your SQL is just always
deltas from the last.  For example, you ship version 1 and create
schema1.sql.  Version 2 you add some stuff so you create a schema2.sql
that adds what you need to the database (just delta).  So if somebody
installs from scratch they run schema1.sql and schema2.sql.  If you
already have version 1, you just run schema2.sql.

This is an extremely common approach and cuts down the need to test the
DB from scratch and upgrade.

Darren




Mime
View raw message