This is a migrated thread and some comments may be shown as answers.

Sync: SQLite to SqlServer

5 Answers 172 Views
General Discussion
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
SwanB
Top achievements
Rank 1
SwanB asked on 19 Aug 2013, 09:19 AM
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

5 Answers, 1 is accepted

Sort by
0
Deyan Varchev
Telerik team
answered on 21 Aug 2013, 08:35 PM
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.
0
Gobi
Top achievements
Rank 1
answered on 19 May 2016, 09:24 AM

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.

0
SwanB
Top achievements
Rank 1
answered on 19 May 2016, 09:30 AM
I second Gobi's request, as SqLite is the most used device db.
0
Gobi
Top achievements
Rank 1
answered on 20 May 2016, 02:07 PM

Hi SwanB,

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

0
Tsvetina
Telerik team
answered on 24 May 2016, 06:58 AM
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.

 
Tags
General Discussion
Asked by
SwanB
Top achievements
Rank 1
Answers by
Deyan Varchev
Telerik team
Gobi
Top achievements
Rank 1
SwanB
Top achievements
Rank 1
Tsvetina
Telerik team
Share this question
or