migrate - SQLAlchemy Migrate (schema change management)

Author:Evan Rosson
Maintainer:Domen Kožar <domenNO@SPAMdev.si>
Source code:http://code.google.com/p/sqlalchemy-migrate/issues/list
Issues:http://code.google.com/p/sqlalchemy-migrate/
Generated:July 13, 2010
License:MIT
Version:0.6

Overview

Inspired by Ruby on Rails’ migrations, SQLAlchemy Migrate provides a way to deal with database schema changes in SQLAlchemy projects.

Migrate was started as part of Google’s Summer of Code by Evan Rosson, mentored by Jonathan LaCour.

The project was taken over by a small group of volunteers when Evan had no free time for the project. It is now hosted as a Google Code project. During the hosting change the project was renamed to SQLAlchemy Migrate.

Currently, sqlalchemy-migrate supports Python versions from 2.4 to 2.6. SQLAlchemy Migrate 0.6.0 supports SQLAlchemy both 0.5.x and 0.6.x branches.

Warning

Version 0.6 breaks backward compatability, please read changelog for more info.

Download and Development

Dialect support

Operation / Dialect sqlite postgres mysql oracle firebird mssql
ALTER TABLE RENAME TABLE yes yes yes yes no not supported
ALTER TABLE RENAME COLUMN yes (workaround) [5] yes yes yes yes not supported
ALTER TABLE ADD COLUMN yes (with limitations) [6] yes yes yes yes not supported
ALTER TABLE DROP COLUMN yes (workaround) [5] yes yes yes yes not supported
ALTER TABLE ALTER COLUMN yes (workaround) [5] yes yes yes (with limitations) [7] yes [8] not supported
ALTER TABLE ADD CONSTRAINT no yes yes yes yes not supported
ALTER TABLE DROP CONSTRAINT no yes yes yes yes not supported
RENAME INDEX no yes no yes yes not supported
[5](1, 2, 3) Table is renamed to temporary table, new table is created followed by INSERT statements.
[6]Visit http://www.sqlite.org/lang_altertable.html for more information.
[7]You can not change datatype or rename column if table has NOT NULL data, see http://blogs.x2line.com/al/archive/2005/08/30/1231.aspx for more information.
[8]Changing nullable is not supported

Indices and tables

Table Of Contents

Next topic

Download

This Page