H2 to MySQL database migration - Anyone done that?
This has been discussed several times on the forum. For example:
https://www.traccar.org/forums/topic/suggestions-for-a-good-migration-tool-to-convert-h2-to-mysql/
https://www.traccar.org/forums/topic/h2-to-mysql/
There's probably more if you search.
Hi Anton,
Thanks for the quick response!
Wrong search keys obviously.
Regards,
Marc
Hi there,
I'm running traccar (v4.12 now) on my server for quite some time.
The H2 database starts growing and growing and is over 1Gb file size now.
I tried migrating to MySQL for easier database management, but found it quite a challange to migrate the H2 database file to MySQL.
I've used SquirrelSQL in an attempt to import/copy paste tables to MySQL, tried copy/pasting content from H2 into MySQL, but bumped into table / database differences and tables in upper case in H2 and lower case in MySQL.
Is there anyone around who's gone through this, so I don't have to reinvent wheels/scripts?
Regards,
Marc