使用一致的类型转换将redmine数据从sqlite迁移到postgres。
redmine_migrator的Python项目详细描述
使用一致的类型转换将redmine数据从sqlite迁移到postgres。
安装
$ 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 verbosity
示例
$ redmine_migrator sqlite:////path/to/sqlite_redmine.db postgresql+psycopg2://user:password@:port/dbname?host=/var/run/postgresql