Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
How not to sync deleted rows

Proposed How not to sync deleted rows

  • Thursday, August 19, 2010 3:29 PM
     
     
    Sign In to Vote
    0

    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.

     

All Replies

  • Thursday, August 19, 2010 3:48 PM
    Moderator
     
     Proposed
    Sign In to Vote
    0

    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 4:12 PM
     
     
    Sign In to Vote
    0
    Thanks, I hope it will help. But is there any Sync Framework API for this?
     
  • Thursday, August 19, 2010 11:46 PM
    Moderator
     
     
    Sign In to Vote
    0
    AFAIK, there's nothing specific in the API that allows you to do this.