Prevent Sync Framework from synching deletes

Question

I'm using MS Sync framework to sync records from branch to server. I'm only downloading changes to the main branch server. However, I wanted to prevent the synced records on the main server from being deleted when the records were deleted from the branch server. I want to be able to only upload and update records from the branch to the server and keep them even when deleted on the branch server.

I searched some techniques to do this but the only workable way for me is to disable the delete triggers on the tables on my server database. Are there better approaches for this?

Answer 1

apart from disabling the delete triggers, you can intercept the changes in the ChangesSelected event and remove the deleted rows so they don't propagate up to the server.

see: Manipulating the change dataset in Sync Fx