> -----Original Message----- > From: Darren Shepherd [mailto:dar...@godaddy.com] > Sent: Monday, August 13, 2012 5:07 PM > To: cloudstack-dev@incubator.apache.org > Subject: schema maintenance > > 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.
+1 I would love to do this. The current cloudstack upgrade procedure is the precursor to this. However, we never got around to complete the actual work. --Alex
