Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Tables Order on scope, works for Inserts but not fot deletes RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Lets  say I have 2 table and a relationship, table A parent, table B child with FK to A.

    When I add the tables to the scope I add first A then B, because if I try to Insert a B, will make a reference to an A that doesn't exist. So that works fine, but, if the Sync Fx has to make a delete on that syncronization, it will try to delete an A that is used on B so it won't do it. Do I have to configure SQL Server to do cascade delete? Does Synx Fx has an option for this?

     

    Thx in advance

    Ramiro

    Thursday, December 16, 2010 4:05 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Ramiro,

    Deletes should be applied in reverse order. So in your example, B should be deleted before A. Are you observing some other behavior in your case?

    SDE, Sync Framework - http://www.giyer.com
    Thursday, December 16, 2010 5:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Sure, so in order to make this work, to make all the inserts and deletes, I have to sync twice the same tables but in different order, right? Doesn't sound like should be already solved?
    Thursday, December 16, 2010 11:16 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    When you add A (parent) and then B (child) when provisioning, sync framework will be smart enough to do insert/update in A then B order and delete in B then A order. So you should not encounter problems with this relationship.

    Tuesday, December 21, 2010 12:25 AM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote
    Not my case, I thnk Sync Framework is not smart enough... at least using it with templates... I had to set Cascade on Delete...
    Friday, December 24, 2010 10:41 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Which sync framework provider and version are you using?
    Monday, December 27, 2010 7:27 PM
    Answerer