locked
How to control sync order? RRS feed

  • Question

  • Hi,
    How could I control sync order so that RI is not break?

    Thank you
    • Moved by Max Wang_1983 Friday, April 22, 2011 9:40 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Friday, November 16, 2007 2:52 AM

Answers

  •  

    From the syn designer, at the right side of the pane to add the tables, there is an UP/DOWN Arrow button. you can use them to move the tables to get the desired order.

     

    Thanks

    Yunwen

    Wednesday, November 21, 2007 7:15 PM
    Moderator

All replies

  • the order you added the table to the syncAdapter collection on the remote provider will be used when applying changes. for insert and update, it will be applied as the same order as the tables in the sync adapter colleciton. for deletes, they were applied in the reversed order. so as long as you added the primary key table prior to the foreign key table, the RI should not be broken.

     

    thanks

    Yunwen

    Monday, November 19, 2007 12:56 AM
    Moderator
  • Hi,
    What if I am using Sync designer? How to control the order?

    Thank you
    Tuesday, November 20, 2007 4:51 PM
  •  

    From the syn designer, at the right side of the pane to add the tables, there is an UP/DOWN Arrow button. you can use them to move the tables to get the desired order.

     

    Thanks

    Yunwen

    Wednesday, November 21, 2007 7:15 PM
    Moderator