March 14, 2017 at 12:15 pm
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 ?
March 15, 2017 at 7:11 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy