Migrate from internal to external database, keeping data?


I would like to perform some analytics on sensor data (aggregate energy sensors with car charging events to identify cost), for which I need access to sensor data (Using HA Docker on Synology).

I know I can use MariaDB or others, but all guides say data up to that point will be lost. Is there no way to migrate existing data to an external database?

I know this thread Migrating home assistant database from sqlite to mariadb - #90 by Mario1
(last update is 1 month old, so the solution proposed by @Mario1 should still work)

Note to myself: take the time to do the migration :wink:

1 Like