Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Android Phone PC
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
Edited 4-Feb-13 5:33am
v2
Comments
Matthew Faithfull at 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 at 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 at 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 at 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
0 Sergey Alexandrovich Kryukov 547
1 ChauhanAjay 170
2 CHill60 130
3 Maciej Los 125
4 RyanDev 108
0 Sergey Alexandrovich Kryukov 9,735
1 OriginalGriff 6,989
2 CPallini 5,825
3 George Jonsson 4,017
4 Gihan Liyanage 3,266


Advertise | Privacy | Mobile
Web02 | 2.8.140926.1 | Last Updated 4 Feb 2013
Copyright © CodeProject, 1999-2014
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