Syncing SQLite with SQLServer using Sync Framework
I'm trying to make an online application which can sync the SQLite database running on an Android device with the SQL running on the server. We have an enterprise app running on .NET and Android; we need to sync their data to retain consistency. It will be a bi-directional sync: any data changes which occur (either on the client or on the database server) should be synced.
I saw that this can be achieved with many approaches but for this scenario I'm advised to use the Microsoft Sync Framework since it automates the sync process and can be handy as well. I did some research on using the Sync framework and found some samples on the Microsoft site. But mostly they are doing offline synchronization: they are basically doing the sync process on the desktop where source and target databases are on the same machine. But for my scenario, this is not the case. I have SQLite on the client machine and SQL on the server so here an online sync process seems to be required.
How should I achieve this?
Answer
they are sample apps, so for simplicity, they just point both source and target databases locally. there's no stopping you from repointing database connections to a remote server.
instead of looking at Sync Framework SDK alone, look at the Sync Framework Toolkit instead. That's the one that addresses non-MS client platforms.