synchronize sqlite database from handheld (windows 5 ce) with mysql (debian lenny)
Posted on 2010-09-07
Could you please instruct me on the best approach to solve the following problem...
I have written an app in c# using .net CF for windows 5 ce ( running on a dolhpin 6100 honeywell ) that inserts data to a database within the windows ce device (sqlite). Now the plan is to be able to unload the data from the sqlite in the windows ce device into a debian box that hosts a mysql database.
At the moment what I do is I place the windows mobile device in the deck on a desktop pc and with active synch I get the sqlite database file that later I ftp it to the debian box that hosts the mysql database.
Then a script reads that file and inserts the record in the database.
What I want to achieve is a more elegant solution that would make it possible to read the file from within the windows mobile device (when I place it in deck or wireless ) and directly unload it in the mysql server.
If I connect the device with the network and assign to it an ip would it be possible to connect to the mysql server from within the windows mobile? Eg have a button that says "Dump Data" that when I press it will try to find the mysql server (specific IP) connect to it and dump the data to the main database?
Or this is quite difficult to be done and I should just try to ftp from within the windows CE to the debian box and upload the file there.
Any other opinions are welcome.