I have a new install thats been running exceptionally well for 3 weeks. The data isn't critical but I'd like to keep it and the performance is a little laggy which im picking is the Database which they don't reccomend for production. I'm only likely to have 2 vehicles and 5 at max but still.
I've got MSSQL Express 2022 already on the server. I followed some instructions and backed up the old H2 Database. Setup the Config to talk to the SQL and set ports and firewall rules and it populated tables into the MSSQL database on a service start.
I then stopped the instance and have managed to connect Squirrel SQL to the Database copy on C: and the new SQL Database and tried to copy and paste the first table I got the error "cannot insert explicit value for identity column in table when identity_insert is set to off".
I then ran a SET IDENTITY_INSERT tc_actions ON; via an SQL Query in SQL SMS and it seemed to work but still couldn't copy and paste tables getting the same error. At this point I put the backed up DB and Config back and its working with H2 again at present. I just noticed running reports can be quite slow and its a good windows server with excess Ram for the processes its running and an SSD for both drives.
Couldn't really find any explicit instructions from anyone who has done this so just wondering if anyone has a good write up on going H2 to MSSQL.
Next step might be going Mysql but I have MSSQL running for a website I host so would be good to utilise that rather than also installing MYSql that I have far less experience on.
Would be really cool if traccar have a backup and restore of Data process that was database agnostic for migrations from server to server and platform to platform.
Any tips and pointers from anyone who's done this greatly appreciated. I know there is a lot of any Microsoft sentiment and people will tell me to go to MySQL but I know MS a lot more and I've always found it a very reliable platform.
I have a new install thats been running exceptionally well for 3 weeks. The data isn't critical but I'd like to keep it and the performance is a little laggy which im picking is the Database which they don't reccomend for production. I'm only likely to have 2 vehicles and 5 at max but still.
I've got MSSQL Express 2022 already on the server. I followed some instructions and backed up the old H2 Database. Setup the Config to talk to the SQL and set ports and firewall rules and it populated tables into the MSSQL database on a service start.
I then stopped the instance and have managed to connect Squirrel SQL to the Database copy on C: and the new SQL Database and tried to copy and paste the first table I got the error "cannot insert explicit value for identity column in table when identity_insert is set to off".
I then ran a SET IDENTITY_INSERT tc_actions ON; via an SQL Query in SQL SMS and it seemed to work but still couldn't copy and paste tables getting the same error. At this point I put the backed up DB and Config back and its working with H2 again at present. I just noticed running reports can be quite slow and its a good windows server with excess Ram for the processes its running and an SSD for both drives.
Couldn't really find any explicit instructions from anyone who has done this so just wondering if anyone has a good write up on going H2 to MSSQL.
Next step might be going Mysql but I have MSSQL running for a website I host so would be good to utilise that rather than also installing MYSql that I have far less experience on.
Would be really cool if traccar have a backup and restore of Data process that was database agnostic for migrations from server to server and platform to platform.
Any tips and pointers from anyone who's done this greatly appreciated. I know there is a lot of any Microsoft sentiment and people will tell me to go to MySQL but I know MS a lot more and I've always found it a very reliable platform.