Switch DB migrations from SQLAlchemy-migrate to Alembic

Registered by yuntongjin

SQLAlchemy-migrate is fine for straight-line migrations, but
1) does not really support branching, needed for clean backports of some but not all migrations to a stable branch.
3) sqlalchemy-migration project is no longer maintained and doesn't accept bug fixed any more.
For more info on the activity of the project, please visit:
http://code.google.com/p/sqlalchemy-migrate/
https://www.ohloh.net/p/sqlalchemy-migrate/commits/summary

2) does not support SQLAlchemy 0.8.x (but seems like some patches are available but not sure if it addresses all compatibility issues)

Neutron and keystone have already adopt alembic:

https://github.com/openstack/neutron/blob/master/neutron/db/migration/alembic.ini
dbf0b22abb5a55e3bab5eb335eb47cd843a7a43d
https://blueprints.launchpad.net/keystone/+spec/alembic

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
yuntongjin
Direction:
Needs approval
Assignee:
None
Definition:
Obsolete
Series goal:
None
Implementation:
Unknown
Milestone target:
None
Completed by
yuntongjin

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.