Can I convert database from beta back to stable 4.97 ?

[costo]

I was wondering if it is possible to convert the database from the beta version back to the old format, so it will be accepted by a fresh new stable installation.
I am using the latest beta version but experience some problems so I would like to go back to 4.9700 and see if that helps.
Mostly I would like to have all my devices with names/idx_numbers back in the stable installation. History is not so interesting , so I can live without that.

[waaren]

I was wondering if it is possible to convert the database from the beta version back to the old format, so it will be accepted by a fresh new stable installation.
I am using the latest beta version but experience some problems so I would like to go back to 4.9700 and see if that helps.
Mostly I would like to have all my devices with names/idx_numbers back in the stable installation. History is not so interesting , so I can live without that.

In general this is not a good idea and Database schema's are different. Between current Beta and 4.9700 the devicestatus table did not change but there has been a change in the hardware table. So just copying these tables between databases will probably not work.

[costo]

In general this is not a good idea and Database schema's are different. Between current Beta and 4.9700 the devicestatus table did not change but there has been a change in the hardware table. So just copying these tables between databases will probably not work.

It's a pity that stable version 4.9700 refuses to accept the beta database. I thought about a little tool to copy certain tables to a new database. It wouldn't be so much work to build the hardware table from scratch and the scripts can just be copied. But that is different for the device table. I have 125 devices and a lot of ESP8266 virtual hardware with ESPEasy on it that uses the idx of devices. To build that from scratch is not my plan.

My database experience (Borland's dBASE) dates back to the late DOS-era. Applications have become so much more complex since that time. I was hoping there excists a tool that makes it simple to selectively copy certain tables from one to another database.

[waaren]

I thought about a little tool to copy certain tables to a new database. It wouldn't be so much work to build the hardware table from scratch and the scripts can just be copied. But that is different for the device table. I have 125 devices and a lot of ESP8266 virtual hardware with ESPEasy on it that uses the idx of devices. To build that from scratch is not my plan.

A tool that you can use for this is sqlite3.
Use at your own risk and not without backup and prooven restore procedure.

Code: Select all

sqlite3 domoticz.db
attach database 'domoticz_beta.db' as beta;
insert into main.deviceStatus select * from beta.DeviceStatus;