Click here to Skip to main content
Sign Up to vote bad
good
See more: AndroidPhonePC
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:32
Edited 4 Feb '13 - 5:33

Comments
Matthew Faithfull - 4 Feb '13 - 12:10
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:46
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:05
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:55
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
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 8,123
1 OriginalGriff 6,040
2 CPallini 3,432
3 Rohan Leuva 2,703
4 Maciej Los 2,234


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