I need to sync two sqlite databases over remote connection for a windows store application. The one device, a tablet is generally offline besides the time it needs to sync. I have looked at the sync framework but there seems to be very little documentation on it, or at at least what i can find.
The previous version of the app was using sqlserver but now because there is no support for it in the windows store side it makes writing line of business apps a bit tricky. I have the app running as it was with the new windows store ui ( and i just got the MVVM model impelmented => soooo much better! ) i am just struggling with the sync process at the moment.
Deletes are a pain in the butt to handle. As long as your tables have a primaryKey and a dateModified column, sync is rather straightforward.
You could have a table that covered when things where deleted.
[Deletes](Id, FromTable, DeletedId, DeletedOn)
@JoshRoss: Yup. Syncing deletes requires transferring all of the PKs of a given table unless you keep a separate transaction log.
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.