In a following app arhicecture, local C# desktop app with SQL Server Express, which need to work offline sometimes and a central web app with SQL Server Enterprise, with db per local app.
I need to sync those two databases semi-automatically, but with some controls (and info) from an local desktop and web apps. For example, I want for user to see when sync start, when it ended, etc. Also, if synced ok or there was an error. In addition, I don't need direct replication between two databases, but I need to copy some rows which belong to the client in the db table from and to the server.
What is the best solution for this problem ?