docker-odoo-migration

Run odoo database migration in docker-compose

About

This repository is a docker-compose to mirgate odoo 9.0 to odoo 13.0 based on the following resources published by dhruvadave5297:

• Odoo Database Migration
• migrate.py

Usage

• Export odoo 9.0 database in production environment
• Using pg_dump to export the datbase

docker exec -it db pg_dump -U odoo -d odoo > /tmp/odoo.sql

• Copy /tmp/odoo.sql to the local machine

• Clone this reposistory

git clone https://github.com/tools-utils/docker-odoo-migration.git

• Start a postgresql database

docker-compose up -d db

• Import odoo 9.0 to local database

# create new database odoo9
docker exec -it db createdb -U odoo odoo9

# import data to the new database
cat /tmp/odoo.sql | docker exec -i db psql -U odoo -d odoo9

Migrate odoo 9.0 to 10.0

• Edit .env

DB_NAME=odoo9
TARGET_VERSION=10.0
PIP=pip

• Start migration

docker-compose up openupgrade

• Logging

tail -200f /tmp/openupgrade/migration.log 

Migrate odoo 10.0 to 11.0

• Edit .env

DB_NAME=odoo10
TARGET_VERSION=11.0
PIP=pip3

• Start migration

docker-compose up openupgrade

Migrate odoo 11.0 to 12.0

• Edit .env

DB_NAME=odoo11
TARGET_VERSION=12.0
PIP=pip3

• Start migration

docker-compose up openupgrade

Migrate odoo 12.0 to 13.0

• Edit .env

DB_NAME=odoo12
TARGET_VERSION=13.0
PIP=pip3

• Start migration

docker-compose up openupgrade