[dev] DB Migration questions

[Jan Schneider]

Zitat von Ben Klang <ben at alkaloid.net>:

> On May 25, 2010, at 5:17 AM, Jan Schneider wrote:
>
>>
>> There is still another "problem" though. Upgrade scripts in  
>> development vs. stable versions. I suggest that we do it similarly  
>> like we do it now. We just have to keep track of schema versions.  
>> Example:
>>
>> In dev version:
>> 4_add_some_missing_index.php
>> 5_add_a_new_column.php
>> 6_drop_another_one.php
>>
>> This should be a single script in stable versions, but the schema  
>> version must match. I suggest that we even round the number up to  
>> the next tens. This looks cleaner and could even help for debugging:
>>
>> 10_app_x_to_y.php
>
>
> Does it really have to be that manual?  Why not just make as many  
> small schema versions as are necessary during development.  For  
> example, IMP 5.0 may be at schema version 127 and 5.1 may be at 139.  
>  As we develop, we can run the upgrade script as often as necessary  
> to move between intermediate versions.

I'm not sure if I understand your question. Or maybe I didn't explain  
my thoughts not good enough. But for the development version, this is  
exactly what I suggested. We can do as many upgrade scripts in  
developement as we like, just like we do it today.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/