I have an Application in ASP.net and SQL server as a back end. I want to deploy this application on client machine. I will also be having the same website hosted in an actual web server which can be accessed thru internet. I want to provide offline data entry at user end. But I also want to synchronize user data with Main Server. which will always be online.
Table structure is same on each instance. Data will collectively reside in main server. Any changes done on local database will automatically Synchronize on main web server.