Sync Server from Multipel Client Using Upload Only option RRS feed

  • Question

  • Sir,

    I have Sql Server 2008 on my server end and Sql CE on Client and , I have a table invTran (clientid,qty) which i want to sync from my 3 client which have different client id now i want to sync my server invTran table from 3 my client , I want only to sync data from client to Server not from Server to Client how this can be achive.


    Friday, December 31, 2010 8:08 AM

All replies

  • If you are using SqlSyncProvider, you could do it this way:

    Setup 3 scopes on the server, each scope is a filtered scope, with different filters on clientId1, clientId2, clientId3. Then you provision the client1 with scope-clientId1, client2 with scope-clientId2, and so on. So on the server, all client records are in the same table, but for each client, they only see the records of their own.

    With above setup, you don't need to worry that a client gets other client's records. Also, to be sure it's a upload only sync, when you do sync from client, set it to upload on the orchestrator, and in case of conflicts (where server may have updated records), use remote win (client win).



    Friday, December 31, 2010 6:12 PM
  • Thanks Jin ,

    As I told i am new for microsoft sync framework i dont know the process of making scope on server . can you please tell me how to make scope on server in detail. I will be highly thankfull to you. And as you say make 3 scope fro each client but if i have 300 client what should I do please tell me.


    Amit Sharma


    Amit Sharma EDP Woodland
    • Edited by amit.edp Saturday, January 1, 2011 6:26 AM Miss Some part
    Saturday, January 1, 2011 6:17 AM
  • Hi Amit,

    There is a lot of information on MSDN to get your started even if you are new to Sync Framework.

    The general topic for database sync on MSDN is at http://msdn.microsoft.com/en-us/library/ee617382(v=SQL.110).aspx
    from there you can take a look at some tutorials about the basic concepts. http://msdn.microsoft.com/en-us/library/ff928494(v=SQL.110).aspx And there is also a working sample you can download and try with Visual Studio at http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3422.

    For defining filtered scope, you can find information at http://msdn.microsoft.com/en-us/library/ff928701(v=SQL.110).aspx.   

    Tuesday, January 4, 2011 6:16 PM