How to Migrate from H2 DB to Mysql

[santhosh T]

We are using h2 embedded DB. We need to migrate from h2 to an external database(Mysql).

[Fabio Racobaldo [Herzum]]

Hi @santhosh T ,

welcome to the Atlassian community!

Here a useful link https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html

Hope this helps,

Fabio

[santhosh T]

What option is helpful for h2 to MySQL?

1. A different database on the same database server,
2. The same database type on a different server (e.g. from one PostgreSQL server to another PostgreSQL server) or
3. A different type of database server (e.g. from a MySQL server to a PostgreSQL server).

[Fabio Racobaldo [Herzum]]

the third one!