locked
Sync only parts of data RRS feed

  • Question

  •  

    Hi,

    How can I sync only part of data of a servertable? For instance I have a salesapplication where I want to sync customer and orders tables. But one Salesperson only needs the data specific for him. I want only data for his customers, orders etc. to be synced bidirectional from/to his laptop. I have only managed to sync all content of a servertable down to the client.

     

     

    Regards

    • Moved by Max Wang_1983 Friday, April 22, 2011 9:05 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Wednesday, January 9, 2008 10:09 PM

Answers

  • Hi,

     

    Well, you can change the SQL commands (incremental inserts\updates\deletes) on the SyncAdapter to filter content (by adding WHERE clause). If you need specific information from the client to do filtering, you should add it to the SyncParameterCollection in the agent configuration.

     

    Thanks

     

    Saturday, January 12, 2008 7:59 PM