Page 1 of 1

Upgrading database

Posted: Tuesday 12 January 2021 10:14
by gemas
Hello,

I'm migrating my domoticz instance to a new raspberry pi.
This runs the latest raspberry os and the latest version of domoticz.
On my old instance I'm running an older version of domoticz (4.10717).

But when I compare an empty database of version 2020.2 to the old one (V4.10717) I see some schema changes.
I copied the domoticz.db from the old instance to the new one.
After restarting the new domoticz instance, the migrated database doesn't get upgraded to the latest schema.

Do I need to do this manually with a command?

Re: Upgrading database

Posted: Tuesday 12 January 2021 14:12
by waaren
gemas wrote: Tuesday 12 January 2021 10:14 After restarting the new domoticz instance, the migrated database doesn't get upgraded to the latest schema.
If you start domoticz with a previous version of the database it will be automatically converted to the version aligned with he domoticz build number. . No manual actions are needed.

Re: Upgrading database

Posted: Monday 01 February 2021 17:45
by gerardvs
First of all I have no intention to hijack this thread but the question I have is almost the same.
Does your answer also apply to version 3.6675?
I'm happy to say that I have version 3.6675 running continuously from feb 2017 with only a handful of reboots in the past 4 years. Unfortunately of luckily... I have to upgrade to a more recent version mainly because I want to make more use of dzVents.
Again sorry to hijack this tread but want to know if migrating from 3.6675 to the current version is doable.

--Gerard

Re: Upgrading database

Posted: Monday 01 February 2021 18:04
by waaren
gerardvs wrote: Monday 01 February 2021 17:45 Does your answer also apply to version 3.6675?
Yes that should work the same.

As always; please make sure you have a recent and tested backup !

Re: Upgrading database

Posted: Monday 01 February 2021 19:20
by gerardvs
waaren wrote: Monday 01 February 2021 18:04 As always; please make sure you have a recent and tested backup !
Sure, that is automated once a day. I'm a bit afraid of messing up my 8 somfy devices but will take the chance.

Thanks again for your help!