MySQL to PostgreSQL migration of existing server

General
1

Hi,
we have relatively large server with 34TB DICOM images and we found that MySQL database is larger than 120GB. Is there an easy way to migrate from MySQL to PostgreSQL? Re-importing will be really slow process and if possible we would like to avoid it.

2

Hello,

The only official way of migrating from MySQL to PostgreSQL is to apply the replication process. Favour the “direct access to the filesystem” approach, as it should be the fastest and the simplest (no need to keep the original Orthanc server with MySQL running).

We don’t provide any SQL export script, as this would require careful validation and quality assurance, but feel free to contribute.

Kind Regards,
SĂ©bastien-

1 Like
3

Note that the DB won’t be smaller with PostgreSQL.