Offline and online application synchronization - how to?

Question

User692348504 posted

 I have a web application that consists of a .Net web app and an SQL back end that is hosted at a remote data center. In case of unavailbility of internet access  Id like to have a local copy that can be accessed at any time.What are the best ways to synchronize the data in the remote database and the one local one? Any ideas on how this could be architectured in a better way (the aim is to over come the internet availability issues) would be much appreciated.
 

Answer 1

User242249085 posted

Do you want two way (i.e. changes to your local database will also appear in the hosted one) or one way (you have a local copy, but any changes you make will not be copied back to the hosted database)?

SQL Server supports replication, which might be the answer (solves the general problem). Depending on what dsata is changing, something build with SSIS (neé DTS) could do it.

Or, if you only need to refresh so often, copy a backup and restore locally (likely the simplest). 

Answer 2

User-1238904273 posted

you can check this url

http://blog.ankitverma.in/2010/03/onlineoffline-database-synchronization/