sqlobject schema migration

[Daniel Fetchinson]

Does anyone know of a tool that makes sqlobject db schema migration easy?

Cheers,
Daniel
--
Psss, psss, put it down! - http://www.cafepress.com/putitdown

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

[Diez B. Roggisch]

Daniel Fetchinson schrieb:
> Does anyone know of a tool that makes sqlobject db schema migration easy?

SQLObject itself has some limited support built in - it merely says what
is different, unfortunately not on a very verbose/technical level. But
you should check it out.

Yet so far I have to see anything better for SA as well :) miruku looks
promising, but lacks a few important features.

Diez

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

[Daniel Fetchinson]

>> Does anyone know of a tool that makes sqlobject db schema migration easy?
>
> SQLObject itself has some limited support built in - it merely says what
> is different, unfortunately not on a very verbose/technical level. But
> you should check it out.
>
> Yet so far I have to see anything better for SA as well :) miruku looks
> promising, but lacks a few important features.

Thanks, I'll look into the built in stuff. I guess the situation with
SA is better but I just don't want to switch from SO following the "if
it ain't broke, don't fix it" principle :)

Cheers,
Daniel
--
Psss, psss, put it down! - http://www.cafepress.com/putitdown

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

[Christoph Zwerschke]

Daniel Fetchinson wrote:
>>> Does anyone know of a tool that makes sqlobject db schema migration easy?
>> SQLObject itself has some limited support built in - it merely says what
>> is different, unfortunately not on a very verbose/technical level. But
>> you should check it out.
>>
>> Yet so far I have to see anything better for SA as well :) miruku looks
>> promising, but lacks a few important features.

Only comparing the model against the database doesn't work perfectly
anyway. Some problems are:

* You can't derive all model features from the database (e.g. whether a
column has been declared as String or Unicode).
* Some features can be implemented in the model only, not in the
database (e.g. default values).
* Some features are not detected properly by SQLAlchemy (e.g. whether
index=True was set on a column).

So it would be nice to have something similar Ruby on Rail's solution
for database migrations, where you need to describe your changes
explicitly. Requires more discipline though.

-- Christoph

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@...
To unsubscribe from this group, send email to turbogears-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---