Only syncng certain data in a table RRS feed

  • Question

  • hi all,

    I'm in the process of implementing the sync framework.  This is my architechure.


     - Winforms application installed on client workstation
     - hosted database which the workstation calls a web service to retrieve data.


    Now, let's say I want to sync the table "tBranch", this table at the server would have data like for eg:

    BranchID   BusinessID   BranchName

    1               1                 Branch1

    2               1                 Branch 2

    3               2                 Company 2 Branch 1



    So now, of course each client workstation is a different client, so client 1 is business 1, and client 2 is businessid 2.  So I only want to sync data for the respective business the client is bound to... so for client 1's workstation, I only want to download where businessid =1.. and so on...  Basicly.. not sync the whole table, but do it query based... is this possible?  How would I achieve that?


    I guess I will use download only syncing cause I need to get the branchid from the server DB to make it unique, but I'll cross that bridge when i get there.


    Any ideas?  


    Thanks alot in advance



    Thursday, May 27, 2010 10:41 AM


All replies