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 ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.