Click here to Skip to main content
Rate this: bad
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 6:32am
Edited 4-Feb-13 6:33am
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 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342

Advertise | Privacy | Mobile
Web01 | 2.8.141220.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