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

Russell Bryant rbryant at redhat.com
Tue Nov 20 16:03:38 UTC 2012


On 11/20/2012 10:54 AM, David Ripton wrote:
> 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.

Sounds good!  Let's have the discussion part on openstack-dev instead of
gerrit, though.  I would post a patch and then start a thread here to
discuss it.

> 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.
> 

-- 
Russell Bryant



More information about the OpenStack-dev mailing list