Migrate Redmine data from SQLite to Postgres with consistent type conversion.
$ pip install redmine_migrator$ virtualenv ~/venv/migrator
$ source ~/venv/migrator/bin/activate
$ git clone https://github.com/avanov/redmine_migrator.git ~/projects/migrator
$ cd ~/projects/migrator
$ python setup.py develop$ python setup.py nosetests$ redmine_migrator -h
usage: redmine_migrator [-h] [-v] sqlite_url postgres_url
Migrate Redmine data from SQLite to Postgres
positional arguments:
sqlite_url SQLite source URL
postgres_url Postgres target URL
optional arguments:
-h, --help show this help message and exit
-v, --verbose increase output verbosityExample
$ redmine_migrator sqlite:////path/to/sqlite_redmine.db postgresql+psycopg2://user:password@:port/dbname?host=/var/run/postgresql