"Upgrade" existing Orthanc instance from SQLite to MySQL

Is there a way to switch to MySQL or Postgres from SQLite, and migrate existing data?

image.png

So there is no possibility for an in-place upgrade from SQLite?
The solution is to replicate the data to another Orthanc instance, do the switch, then do the replication again?

indeed. Your understanding is correct

Alain,

Just out of curiosity, are the table schema different depending on the backend SQL server used (sqlite vs mysql vs postgre)?

So you couldn’t run a sql dump form sqlite and then load the same sql into an empty PostGre database?

John.

No, this is not possible as there exist different variants of SQL.

Even if 90% of the DB schema is shared between SQLite, PostgreSQL and MySQL, the dialects are not fully compatible.