[openstack-dev] [Openstack] DB Migrations - switch to Alembic

David Ripton dripton at redhat.com
Tue Nov 20 15:54:05 UTC 2012


On 11/20/2012 03:21 AM, Endre Karlson wrote:
> Hi, I was wondering if anyone has tested using alembic as a tool for
> OpenStack projects instead of SQLA Migrate?
>
> I'm wanting to use alembic for new projects (Moniker and Bufunfa)
> instead of migrate if possible.
>
> https://etherpad.openstack.org/nova-backportable-db-migrations

(Crosspost trimmed.  Please don't crosspost to openstack and openstack-dev.)

I tested using Alembic for the big batch of existing Nova migration 
scripts a few weeks ago.  The conversion script I wrote is at 
https://review.openstack.org/#/c/15196/  (Don't expect miracles; it 
handles the first 90% but you still need to manually hack a few things.)

Alembic worked fine for me, in limited testing.

After all of Dan Prince's current migration changes land, I plan to 
repeat the process and test more thoroughly, then drop a big patch on 
Gerrit for discussion.  So stay tuned.

The good news is that migrate and Alembic aren't *that* different, so if 
you pick the wrong horse you can definitely convert your work to the 
other one.

-- 
David Ripton   Red Hat   dripton at redhat.com



More information about the OpenStack-dev mailing list