Yeah, simplistically you put an update timestamp value in each row, then query the rows that were changed since last update. Then it's a simple matter of converting the query data to inserts/updates on the other side. Two-way synchronization is only a little more complicated -- you basically do the same thing on both sides, and have each side keep track of the last timestamp it saw from the other side. Serial numbers can be substituted for the timestamps, to save a little space/ bandwidth.
Simpler still, you could do a SQLite .dump of the entire DB, then transmit that. The dump output might need some slight reformatting, but should be pretty much ready to just feed in to the SQL engine on the other side. Note, though, that this scheme is largely limited to one-way sync. On Mar 10, 11:20 pm, Rohith Nandakumar <[email protected]> wrote: > Hello, I have an existing desktop application in vb that is using .mdb file > as database. > > I have created an android app to use some of the features of the app. Since > android doesn't support mdb, I've converted the important tables to sqlite > database. I wish to transfer the data in the sqlite db to the the desktop > application when I connect my phone. So basically I want to transfer the > sqlite db to mdb format. Is there any way to do this? -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
