Push and pull data between SQLite and SQL Server

[M]

Hello,

One of the most important aspects of a mobile application is the ability of downloading the data from SQL Server and then taking the application offline. Users can work on the application in offline mode. And when the application is made online, the changes are pushed from the mobile application to SQL Server. 

Is that feature available in the Telerik RAD Controls for Windows 8. I would like to know about this because sync of data is one of the most important requirement in developing a mobile application. Please let me know.

Thanks,

Rajesh.

[Tsvetina]

Hi Rajesh,



The RadControls for Windows 8 HTML suite includes a Data Storage component that allows you to store data locally using SQLite. It has integration with the DataSource component that is used to bind all databound controls in the suite (Grid, Chart, Scheduler, etc.). Furthermore, it exposes fluent API that makes it much easier to work with the underlying SQLite database.



For more information about the component, you can check the Data Storage for HTML page on telerik.com and its documentation. 



Let us know should you have further questions after browsing these resources.



Regards,

Tsvetina
Telerik

[M]

Hi,

I had a look at this Data Storage and saw that the diagram shows connectivity between the application and SQLite database via CRUD.

But it does not say anything about the connection to a back end SQL Server which will be on a remote server and has to be accessed via HTTP. Data has to flow between the SQLite database on the windows 8 tablet and SQL Server hosted on a public IP Server.

(Please think of this as similar to RDA for Windows Mobile /SQLCE where RDA takes care of the inserts/updates so as not to create duplicates.)

Please let me know about this and I also observed that it is in Beta.

Thanks,

Rajesh

[Tsvetina]

Hi Rajesh,

Currently, the Telerik Data Storage component is designed as a wrapper around SQLite, so its features step on the SQLite engine, which is only aimed at client-side data storage. For this reason, the Telerik Data Storage does not implement synchronization with a remote server.

If your goal is to allow users to have their data synced between multiple devices, you can take advantage of the built-in Windows Runtime roaming app data store in combination with Telerik Data Storage.

If you want to allow users to insert/update data in a common remote location, you would need to manually do the synchronization between locally stored data and the remote DB.

As for the Beta stage of the component, it is already quite stable in later versions of the product (latest is Q3 SP1 or 2013.3.1105) and it will go out of Beta in February 2014 (Q1 2014).

I hope this information helps.

Regards,
Tsvetina
Telerik