I recently went through a server upgrade and at the same time updated Traccar to the latest version. As I did a clean install I need to import a significant amount of positional data from the saved database from the previous version. I also had about 6 months worth of data from an early version too. I wish to combine all the results into 1 table. The 2 versions I have do not have the same number of columns in the position table. The earlier version has only 6 tables with the POSITIONS table has 12 columns. The later one has 18 tables and the POSITIONS table has 14 columns. My question is, are there any other changes to the database layout in the latest version of Traccar? I have used the web UI from Litvak for a while and I guess some of the extra tables come from that.
Regards
Database schema for Litvak version is completely different from database schema for Traccar 3.x. Stored data for positions should be similar/same, so you should be able to copy data manually.
I recently went through a server upgrade and at the same time updated Traccar to the latest version. As I did a clean install I need to import a significant amount of positional data from the saved database from the previous version. I also had about 6 months worth of data from an early version too. I wish to combine all the results into 1 table. The 2 versions I have do not have the same number of columns in the position table. The earlier version has only 6 tables with the POSITIONS table has 12 columns. The later one has 18 tables and the POSITIONS table has 14 columns. My question is, are there any other changes to the database layout in the latest version of Traccar? I have used the web UI from Litvak for a while and I guess some of the extra tables come from that.
Regards