Skip to content

DatabaseMigration

Mike Bayer edited this page Feb 13, 2014 · 1 revision

Database migration

Database migration requires a possibility to issue "alter table" statements for tables that changed. It should be able to drop tables that where removed, and detect tables that are new to issue them for creation.

The create/drop stuff is quite easy. Altering tables is what probably needs more work.

Data migration is another issue and quite outside the scope of getting it done automatically.

As a startpoint for discussion, how would sqlalchemy be able to generate alter table statements?

Third party tools

Migrate:: migrate adds migration support to SA > 0.4

Miruku:: miruku is another tool based on SA

Gerald:: gerald is an indipendent tool, not based on SA, that support migrations on MySQL, Oracle and Postgres

Clone this wiki locally