Migration from SQLite to MariaDB

[SP5MTD]

Hi, I started logging my QSOs using SQLite, but now considering switching to MariaDB, so I can access my data
a from different computers.

Is it as simple as exporting all logged QSOs to ADIF files, connecting to MariaDB and importing saved ADIFs into new database?

Configuration is not dependent on database? shall I just copy AppData/Roaming/Log4OM directory?

[G4POP]

Why bother?

I have been accessing a common SQLITE database for 10 years from 3 PC's using Google Drive or Dropbox

Why not check the user manual and this forum by searching on word 'Dropbox'

Unless your running several contest stations at the same time or have over 120K QSO's MySql is not needed

[SP5MTD]

I do not like to use cloud services, I have good backup for my self-hosted MariaDB and also my own VPN access. I consider such a setup independent and more future proof.

[G4POP]

Your choice

[SP5MTD]

I know . So any idea if exporting / importing logged QSOs as ADIFs is the way to go? Will I get full data into new DB?

[G4POP]

I know . So any idea if exporting / importing logged QSOs as ADIFs is the way to go? Will I get full data into new DB?

Just follow the instructions in the user guide

[SP5MTD]

Just follow the instructions in the user guide

There is no instruction in the user guide for database migrations, a least I didn’t find any. My gut feeling is that ADIF export / import should to the job. The only doubt is if I cover all data that way.