Synchronization of SQL Server db tables based on a condition

• brisiodmah

  SSC Enthusiast

  Points: 108

  More actions

  March 14, 2017 at 12:15 pm

  #335731

  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: 738112

  More actions

  March 15, 2017 at 7:11 am

  #1933235

  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