winform Application and ASP.NET Application with Single DB

If you don't want application to do this, but sql server in background to do this, Ref. https://stackoverflow.com/questions/22498952/sql-synchronize-database-between-local-and-remote-server

 

If you want an application to do this, then design decision need many parameters like how frequently you need replication, is it override or merge replication etc....But overall approach is to make a de-coupled service to pull data from remote and push in to local.