WTH is DB migration (sqlite to mariadb/influx) not automated

Archive Month of "What the heck?!" 2022
1

I started out with HA using the “default settings”, to learn that the data size grows pretty big after many months and that the sqlite3 DB is not that efficient to retrieve data.

When I want to migrate (after installing the influx and mariadb addons) it turns out that I can’t just click and migrate, I have to perform raw SQL requests to migrate from one system to the other and there always seem to be some exceptions that are reported.

WTH is that not automated and maintained in the core?

2

Just a note that InfluxDB is just an addition to the HA own database. It would be great to copy all data from HA history to the InfluxDB during the InfluxDB setup but this is not a migration. Sqlite to MariaDB is what you need to migrate.