How to sync Client database with Server database containing data for all clients? RRS feed

  • Question

  • Hello


    For example


    Client has table "orders"

    Server has table "orders", but server table contains orders for all clients. Column "ClientID" specify client.


    Werein difference in sync in this approach and in standart approach where client table refer to server table in relation 1 client - 1 server?



    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:07 PM forum consolidation (From:SyncFx - Technical Discussion [ReadOnly])
    Tuesday, May 27, 2008 5:23 AM


  • This sounds like you are looking like a solution like Sync Services for ADO.NET which is a component of the Microsoft Sync Framework that enables synchronization of ADO.NET enabled server databases to client side SQL Server Compact databases. 


    There is a webcast here that walks through the process and an overview document here.




    Wednesday, May 28, 2008 6:33 PM