Sync sqlite with sql server

Discussion in 'iOS Programming' started by RookieAppler, Sep 26, 2012.

  1. RookieAppler macrumors member

    Mar 15, 2012
    i am to develop an app for ipad. I have prior experience with android development.School assignments and stuff. I have OO programming experience but none so far about ipad development. I am interested in developing apps. So, my question is suppose i have a sqlite3 on my ipad with data in it. When the client connects to wifi and tries to sync his/her ipad with sql server on their windows server it has to merge this ipad data (where sqlite3 is present with tables and stuff) with the sql server. How can it be done? Can you point me in the right direction? Thanks.. I have more questions..:)
  2. ViviUO macrumors 6502

    Jul 4, 2009
    Since you are using SQL Server, you may want to consider writing a .NET web service to act as a middleman between your device and your database.
  3. RookieAppler thread starter macrumors member

    Mar 15, 2012
    Sync ipad and sql server ; connect on cellular

    @ ViviUO Thanks. I did that. I have an XML web service that acts as middleman which takes care of transmitting data back and forth. I have also in the mean time saved data to core data.
    So now to sync these both how do i do that?Meaning user is somewhere on field and saves data to his iPad (core data). When he reaches his office he will sync it with SQL server and the data on iPad should be transferred to SQL over wifi.

    Also i have a new question. I looked up apple documents and found Reachability to detect wifi. I tried out that example and it worked out correctly. It detects wifi and lets me transfer data to sql server if it is available. Now i turned off WiFi and i am checking for a cellular signal. In the example i saw reachable with WWAN. The corresponding flag for that "kSCNetworkReachabilityFlagsIsWWAN" is never turned on. How do i turn it on so to check if WWAN signal is present and if it is present tell the user to either use it or not to use it depending on his data plans.
    If more information is needed please let me know.

Share This Page