Page 1 of 1
Moving SQL Lite database to the cloud
Posted: 26 Sep 2021, 09:18
by g3yiq
When I originally set up Log4OM I hosted the database on my local computer. I now want to move it to OneDrive so that I can access it from more than one computer. I realise I could export the whole database as an ADIF file, then set up a new one in the cloud, import everything to it and delete the old one, but is there a simpler way?
Re: Moving SQL Lite database to the cloud
Posted: 26 Sep 2021, 10:27
by DF5WW
Have you tried to copy the complete database into a place of your OneDrive folder and change the
link to the database in your Log4OM settings ? That should be the easiest way.
Re: Moving SQL Lite database to the cloud
Posted: 26 Sep 2021, 11:08
by G4POP
g3yiq wrote: 26 Sep 2021, 09:18
When I originally set up Log4OM I hosted the database on my local computer. I now want to move it to OneDrive so that I can access it from more than one computer. I realise I could export the whole database as an ADIF file, then set up a new one in the cloud, import everything to it and delete the old one, but is there a simpler way?
Just copy the sqlite file to your cloud storage then in File/open (New) database navigate to the new location and open it followed by Save and apply.
Be aware that using OneDrive may require you to rum Log4OM as an administrator due to the Microsoft security system.
Re: Moving SQL Lite database to the cloud
Posted: 26 Sep 2021, 18:59
by g3yiq
Thanks, Terry. That's a little more elegant!
73 Bob