[Vtigercrm-developers] How to sync local SQLite database in mobile and Server side Vtiger mysql database

[Adam Heinz]

You might want to ask this same question on DBA forums.  That said, I
see  three main options.

1. Use web service API to pull accounts.  I think this is going to be
absolutely brutal on your network traffic, but you may be able to
mitigate that to some extent if you are able to filter on
vtiger_crmentity.modifiedtime
2. Dump/restore.  Exactly what it sounds like.  Use mysqladmin dump
for the tables you are interested in, copy them to the mobile device,
then restore into SQLite.
3. Offline replication of select database tables.  Haven't done this
myself, but at least you have the "offline replication" term to google
for now.  ;)

On Tue, Jul 24, 2012 at 12:40 AM, ram prasad <ramtrg at gmail.com> wrote:
> Hi
>
>    I am developing an Android Application using Phonegap(HTML 5,mobile
> jquery). I have  created vtiger_accounts table in SQlite in mobile. i want
> to sync this database table and server side Database table(vtiger_account).
> What are the steps need to do this?
>
> Also i have seen Vtiger Mobile API. This document not provides details from
> scratch clearly.
> Shall i want to do for loop to check my local table record and server side
> record?
>
> Please provide suggestions to start sync local database in mobile with the
> Vtiger mysql database.
>
> --
> BY
>
> R.RAMPRASAD
>
>
> _______________________________________________
> http://www.vtiger.com/