Godwit

Godwit aims to be a super duper slim and minimalistic tool to migrate databases.

Currently, it support PostgreSQL, using psycopg2. It should be a very small job to get it to work with another database.

Installing

You can install Godwit using pip:

pip install godwit

To install from source, Godwit uses distutils, run this:

python setup.py install

Usage

Migration is done through a number of SQL scripts. These scripts should be put into their own directory (see the example directory). The scripts must use the extension .sql. The name of the file (without the .sql extension) is called the "version" of this script. Versions are ordered in lexicographic order.

Migration can then be run from the command line:

python -m Godwit [host] [database] [username] [password] [script-dir] [version]

This will connect to the provided host and database, and migrate the database to the provided version using the scripts in script-dir.