Migrating from H2 to Mysql

You k6 years ago

Hi Tananaev,

hope you are doing well, i'd like to migrate my H2 database to Mysql, i'm awre of the procedure to follow but my current database contains multiple devices i production, so I wanted to know if I'm doing the migration, will I find all the devices already configured ? or I need to convert the database H2 to mysql to avoid a golive ? looking forward to your reply

Anton Tananaev6 years ago

If you want to keep the data, you need to copy it somehow to the new database.

You k6 years ago

thanks for your return, would it be possible to copy data belonging to a database H2 to Mysql2 directly without conversion?

Anton Tananaev6 years ago

I don't understand the question.

You k6 years ago

how do i copy the data from the old H2 database in mysql (new one ) ?i know that there is 2 files ( database.mv.db and database.trace.db) but what is the exact procedure to follow ?

Anton Tananaev6 years ago

Both are SQL databases. You need to find some software that can migrate the data.

You k6 years ago

thanks Anton, I planned to use Metabase Migration tool for this purpose

Armstrong6 years ago

Is this some kind of escape game or a support forum ?!

Anton Tananaev6 years ago

Armstrong, is this some kind of joke? Or are you seriously complaining about free support that I provide?

Lukas Z.6 years ago

Hi Karim, did You successfuly migrate from H2 to mysql?