Syncing Data from Sqlite to Microsft SQL in Xamarin

Question

Hello

I have been doing some work on Xamarin and have started to use the NuGet package sqlite-net-pcl as a local database, right now it is just a simple note taking app. I am wondering if it is possible to then send/sync everything that is on the sqlite table to a main data table on a Microsoft Azure SQL Server? Can this be done with the NuGet package or do extra steps need to be taken. I have looked for a straight answer a variety of places but can't seem to find anything, any links to other posts, videos and such more than welcome!

Thanks
C

Answer 1

You can use Microsoft Sync Framework to Sync SQLite and SQL Azure/SQL Server as explained here. Syn Framework provides cross-platform data synchronization.

This synchronization framework published on GitHub may be a possible solution for you.

Alternatively, you can create your own Web Api in front of the SQL server to handle SQL DML statements. Please refer to this forum thread for detailed information.