Synchronization of SQL Server db tables based on a condition

  • brisiodmah

    SSC Journeyman

    Points: 78

    I have a following scenario: multiple windows client apps (C#, occasionaly offline app) with SQL Server express, and a central web app (ASP.NET) with SQL Server standard. I need to sync clients db with central db, however some client tables need to be bi-directionaly synced completely with server, but some tables from client need to be bi-directionaly synced in a way, e.g. where rows from client table, need to be located in the same table on the server but with client_id column of the client (i.e., table which aggregates client rows). Also, it would be good that client from the app see sync results and some kind of a progress.

    What is the best tech stack/architecture for this challenging problem ?

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714698

    Replication, though not sure you can bi-directional with Express.

    Otherwise. The MS Sync framework - https://msdn.microsoft.com/en-us/library/bb902829(v=sql.110).aspx

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply