locked
how to sync one table at a time RRS feed

  • Question

  • actually I am using syncgroup class,combine all the tables and sync between server and client at a time.
    how to do table by table?

    Thanks, Bharathi
    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:33 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Wednesday, October 28, 2009 5:10 AM

Answers

  • Hi,

    If you want to sync one table per sync session, you need to create different sync providers for each table. If you just want to sync one table per transaction, you can put your tables in different SyncGroups to achieve it. Still, you need to ensure the sync order of your tables for PK-FK referential integrity.

    Thanks,
    Dong
    This posting is provided AS IS with no warranties, and confers no rights.
    Wednesday, October 28, 2009 4:53 PM
    Moderator

All replies

  • Hi,

    If you want to sync one table per sync session, you need to create different sync providers for each table. If you just want to sync one table per transaction, you can put your tables in different SyncGroups to achieve it. Still, you need to ensure the sync order of your tables for PK-FK referential integrity.

    Thanks,
    Dong
    This posting is provided AS IS with no warranties, and confers no rights.
    Wednesday, October 28, 2009 4:53 PM
    Moderator
  • hi ,

    providing new syncgroup for each table will improve the performance or clubbing the tables in syncgroup will improve the performance?
    Wednesday, November 25, 2009 4:29 AM