Multi Migration (version and database)

I am currently running a redmine installation (3.4.5.stable) on a mySql database, installed natively on Ubuntu 14.04.

Currently, I plan to transfer this to a docker installation in ubuntu 18.04. While I am at it, I was planning to upgrade to redmine 4.0.2.stable on a Postgres database.

Since this will need 2 steps of migration, I am unsure how to proceed:

1. migrate the database from 3.4.5 to 4.0.2 and stick to MySQL; after this is successful, migrate to Postgres
2. migrate the database from MySQL to postgres and stick to 3.4.5; after this is successful, migrate to 4.0.2

Is there any experience with this and are there recommendations whether to use option 1 or 2?

Strictly, Postgres is not a critical thing, but the version upgrade surely is.

Thank you for any input!

All the best, Martin

Replies (1)

RE: Multi Migration (version and database) - Added by Go MAEDA about 5 years ago

Martin Jung wrote:

1. migrate the database from 3.4.5 to 4.0.2 and stick to MySQL; after this is successful, migrate to Postgres
2. migrate the database from MySQL to postgres and stick to 3.4.5; after this is successful, migrate to 4.0.2

I think both are technically OK but I prefer the first option because you will be able to experience new features of 4.0 earlier.

(1-1/1)

Project

General

Profile

Redmine