Click here to Skip to main content
13,085,936 members (88,556 online)
Rate this:
Please Sign up or sign in to vote.
I have a question about remote connection

what is the best way to update the data in application of Phone(Android) according to Data in MS SQL in Personal computer?

(I mean , when we Update data in personal computer, the data in application (android) should also update.)

I'd appreciate your help
Posted 4-Feb-13 5:32am
Updated 4-Feb-13 5:33am
Matthew Faithfull 4-Feb-13 12:10pm
As MS SQL doesn't run on the Android platform you'll either need to export your data to a database that does like SQL lite and then set up synchronisation between your database machine and your Android device or store your data in the cloud so you can access it from anywhere including your android. There are a very large number of solutions around for that sort of thing now.
Member 9810183 4-Feb-13 20:46pm
Thanks for your reply
I used SQLite but I don't know how to setup synchronisation

could you please give me an idea?
Matthew Faithfull 4-Feb-13 21:05pm
It's out of my experience, I'm literally setting up for Android development at this minute, SDK just installed now. In principle you need to have SQL lite on both ends (one on the device and one on the desktop) with identical structure of database then you're going to need a tool to do the actual sync. You could use a file sync tool like rsync or may even Kies will do it. I guess there will be SQL lite specific tools that will do it better, being sure not to break your database if it in use and that sort of thing. I can only recommend more googling.
Member 9810183 4-Feb-13 21:55pm
Thanks a lot :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 4 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100