<div>
Did you looked into this option ? &quot;Database mirroring&quot;. More information in this link, <a href="http://msdn.microsoft.com/en-GB/library/ms151799.aspx" rel="ugc">http://msdn.microsoft.com/en-GB/library/ms151799.aspx</a>
</div>


Did you looked into this option ? "Database mirroring". More information in this link, http://msdn.microsoft.com/en-GB/library/ms151799.aspx [http://msdn.microsoft.com/en-GB/library/ms151799.aspx]

<div>
I would caution against using mirroring as Microsoft has issued a warning that mirroring will not be supported (removed) in future versions of SQL Server. &nbsp;With SQL 2012 the recommendation is to use availability groups.<br />
<br />
1. What OS?<br />
2. What version of SQL Server (or other database engine)?<br />
3. Will both instances of the database be writable?<br />
<br />
Dan
</div>


I would caution against using mirroring as Microsoft has issued a warning that mirroring will not be supported (removed) in future versions of SQL Server.  With SQL 2012 the recommendation is to use availability groups.

1. What OS?
2. What version of SQL Server (or other database engine)?
3. Will both instances of the database be writable?

Dan

<div>
It is Window Server 2008 R2, and Window SQL Server 2008. &nbsp;I don't allow to configure the sql server. All I can do is to create stored procedures or SQL statement.
</div>


It is Window Server 2008 R2, and Window SQL Server 2008.  I don't allow to configure the sql server. All I can do is to create stored procedures or SQL statement.

<div>
<div class="content wysiwyg-content">
I want to create a data synchronization feature between two database on the web service. Basically, I want asp.net webservice to get data from database1 and the data will be import into database2.<br />
<br />
Both database1 and database2 is the same structure. Just different physical location.<br />
<br />
Can you show me how to do that?<br />
<br />
Thanks
</div>
</div>


I want to create a data synchronization feature between two database on the web service. Basically, I want asp.net webservice to get data from database1 and the data will be import into database2.

Both database1 and database2 is the same structure. Just different physical location.

Can you show me how to do that?

Thanks

web services

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.

Web Services

Windows Communication Foundation (WCF) is a tool used to implement and deploy a service-oriented architecture (SOA) to support distributed computing where services have remote consumers. It features a runtime and a set of APIs in the .NET Framework for building connected, service-oriented applications. Services typically have a WSDL interface (Web Services Description Language) that any WCF client can use to consume the service, regardless of which platform the service is hosted on. WCF implements many advanced Web services (WS) standards such as WS-Addressing, WS-ReliableMessaging, WS-Security, RSS Syndication Services, WS-Discovery, routing and better support for REST services.

IIS is Internet Information Services, the web server included with Windows Server operating systems. All current versions are built on a modular architecture; modules can be added or removed individually so that those required for specific functionality are installed. The full installation of IIS includes HTTP, security, content, compression, caching, logging and diagnostics.