Last post Mar 23, 2010 07:58 AM by firstname.lastname@example.org
May 17, 2008 09:41 AM|codemister|LINK
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.
May 19, 2008 11:25 AM|rjcox|LINK
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).
Mar 23, 2010 07:58 AMemail@example.com|LINK
you can check this url