Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How not to sync deleted rows RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I'm new to Sync Framework and now I'm investigating on its features.

    In my test app I have implemented synchronization between SQL CE and SQL Express using SqlSyncProvider and SqlCeSyncProvider. The synchronization is done using SyncOrchestrator class. First of all, I'd like to modify my code so that only inserts and updated should be synced between client and server.  Deletes in client or server database should not be synced.

    I wonder how I can do this? Should I use custom sync provider classes, or some custom SQL script? Please help me with this problem.

     

    Thanks.

    Thursday, August 19, 2010 3:29 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    try disabling the Delete Trigger created by Sync Fx when provisioning. There will be one for each table in the scope.

    Thursday, August 19, 2010 3:48 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks, I hope it will help. But is there any Sync Framework API for this?
    Thursday, August 19, 2010 4:12 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    AFAIK, there's nothing specific in the API that allows you to do this.
    Thursday, August 19, 2010 11:46 PM