Sync: SQLite to SqlServer

6 posts, 0 answers
  1. SwanB
    SwanB avatar
    44 posts
    Member since:
    Oct 2006

    Posted 19 Aug 2013 Link to this post

    Hello,

    Considering using Icenium for Crossplatform development, we do have a question regarding Syncing of SQLite to SqlServer.

    We do understand that we may use Odata approach for syncing, and then roll our own sync. 

    From previous experience, we do know the Microsoft Sync Framework fairly well. Do Icenium offer any plugins / approaches for syncing subsets of SQLserver to SQLite databases of size 1 - 10 mb (on device) ?

    Any sample code ?, any URL links or suggestion for approaches are higly appreciated.
    (If wrong forum, please move post or suggest otherwise)

    SwanB
  2. Deyan Varchev
    Admin
    Deyan Varchev avatar
    150 posts

    Posted 21 Aug 2013 Link to this post

    Hello,

     Unfortunately there is no out-of-the-box solution for your request. As you saw you can easily integrate local SQLLite database through cordova plugin but that won't offer data synchronization with a remote DB. 
     The closest thing that I can think of is the open-source project WebSqlSync (https://github.com/orbitaloop/WebSqlSync). It offers a Javascript library that handles some of the work needed on the client, but you still need to hook up your own server-side code to return the necessary responses.
     
     I hope this will help you find a solution for your problem. If you have any other problems or questions, please don't hesitate to contact us again.

    Regards,

    Deyan Varchev
    Telerik

    Do you enjoy Icenium? Vote for it as your favorite new product here (use short code H048S).
    Looking for tips & tricks directly from the Icenium team? Check out our blog!
    Share feedback and vote for features on our Feedback Portal.
  3. Gobi
    Gobi avatar
    2 posts
    Member since:
    May 2014

    Posted 19 May in reply to Deyan Varchev Link to this post

    Hello,

    Can you please give the sample app to sync with server (api developed in asp.net mvc and backend azure sql server)  as soon as possible.

  4. SwanB
    SwanB avatar
    44 posts
    Member since:
    Oct 2006

    Posted 19 May Link to this post

    I second Gobi's request, as SqLite is the most used device db.
  5. Gobi
    Gobi avatar
    2 posts
    Member since:
    May 2014

    Posted 20 May in reply to SwanB Link to this post

    Hi SwanB,

    my e-mail id is gobimca2012@gmail.com . can you please share your experience of sync sqlite with sql server database.

  6. Tsvetina
    Admin
    Tsvetina avatar
    1876 posts

    Posted 24 May Link to this post

    Hello Gobi and SwanB,

    Such an implementation is now possible in the Telerik Platform product. You can use the offline storage feature of Backend Services and implement a custom SQLite provider for the offline storage. To do this, you need to implement the methods listed in this section:
    Implementing Custom Offline Storage in Telerik Backend Services

    Regards,
    Tsvetina
    Telerik
     

    Visit the Telerik Verified Plugins Marketplace and get the custom Cordova plugin you need, already tweaked to work seamlessly with AppBuilder.

     
Back to Top