I have a desktop application to store various data in a database (up to 10k datasets). Then i have multiple mobile devices (Android and Apple) to collect data by user-input (up to 2k datasets).
Assuming a not existing wlan or internet connection: what is the best way to transfer or synchronize data between Desktop - Mobile and vice versa ? I would try to copy the db-file to the mobile device and update the mobile-db via script comparation (slow..). A) How to access usb-connected mobile storage via desktop-app? B) How to find, read and write those files on mobile?
Assuming i have wlan if i come home with mobile and dont wanna mess with usb. C) Transfer data via multiplayer-communication-stuff? Like the two running apps communicate via chat-like system. One dataset per message; then parsed to desktop-db. ... seems also slow.
Best solution would be.. both ^^ the user should be able to choose. What do u folks think ? :)