Is there any sample code or project which does CRUD using SQLite but does offline sync with AZURE?

[yasmin-amajeed]

the demo tutorial is based on using AZure db, does not show how to sync the SQlite database.
Can you help, I am using Java and Android studio
How to sync multiple tables in local storage(SQLite) to Azure cloud ? How to setup back-end and database for that

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 3c26239e-ff1d-ee65-0203-b49d304b0e76
• Version Independent ID: 30e9c3da-a2a5-af44-8ed2-33125ec64c31
• Content: Enable offline sync for your Azure Mobile App (Android)
• Content Source: articles/app-service-mobile/app-service-mobile-android-get-started-offline-data.md
• Service: app-service-mobile
• GitHub Login: @conceptdev
• Microsoft Alias: crdun

[BryanTrach-MSFT]

@yasmin-amajeed Thanks for the feedback! We are currently investigating and will update you shortly.

[conceptdev]

@yasmin-amajeed see the offline data sync page for an explanation of how the Azure App Service Mobile Apps offline sync feature works. It is intended as a 'local cache' for data queried from the server -- the local data store (which may be SQLite) is transparent to the developer.

It is not intended to provide a synchronization service for an arbitrary local SQLite data store, as you described. If you can fit your data into an Azure App Service back-end, you could then take advantage of this feature. Alternatively, you might want to investigate a 3rd-party solution that helps with data synchronization between clients and the server.

[BryanTrach-MSFT]

@yasmin-amajeed We will now proceed to close this thread. If there are further questions regarding this matter, please tag me in your reply. We will gladly continue the discussion and we will reopen the issue.

[gojanpaolo]

Hello @BryanTrach-MSFT @conceptdev Is there a way to do this on a SQLite database in a windows desktop computer?
We primary develop windows desktop apps using WPF that saves data in a local SQLite database.
Thanks!

[conceptdev]

Refer to the offline sync for Windows documentation.

[gojanpaolo]

@conceptdev Thanks for the response! I'm assuming that this approach will also work on non-UWP apps (e.g. WPF)? It would be nice to include that on the said page to be clear for users (like me 😄) Thanks!