Upgrade Traccar 5.9 and migrate from MySQL to SQL Server

Hello,

We are planning to modernize our current Traccar environment.

Current environment:

Traccar 5.9
MySQL 8.0
Traccar and MySQL running on the same server
Existing production database with historical tracking data

Target environment:

Upgrade Traccar to a current 6.x release
Run Traccar and the database on separate servers
Potentially migrate from MySQL to Microsoft SQL Server

Could you please advise:

Is a direct upgrade from Traccar 5.9 to the current 6.x release supported, or should we use intermediate versions?
Is running Traccar and the database on separate servers fully supported?
For preserving the existing history, is there a recommended approach to migrate from MySQL to SQL Server, or would you recommend upgrading Traccar on MySQL first and changing the database in a separate step?

We will validate everything in a non-production environment and keep backups of the database, configuration, and media files.

Thank you.

You can upgrade directly from 5.9 to the latest. Running database anywhere is supported, but remote is not recommended.

I would definitely recommend upgrading on MySQL first instead of trying to combine the two things.

Thank you for the clarification.

When you say that a remote database is not recommended, does this also apply when the Traccar application and database are on separate VMs within the same cloud region and private network, or mainly when there is higher network latency between them?

Even if it's the same network and region, network latency is much higher than local access.