Replication is an important and powerful technology for distributing data and stored procedures across an enterprise. The replication technology in Microsoft SQL Server allows you to make copies of data, move those copies to different locations, and synchronize the data automatically so that all copies have the same data values. Replication can be implemented between databases on the same server or between different servers connected by LANs, WANs, or the Internet.
By combining Microsoft SQL Server with Microsoft Proxy Server, you can replicate data over the Internet without compromising the security of your database. The steps involved in implementing replication over the Internet are configuring the network topology, understanding the security methodology, configuring Microsoft Proxy Server, and configuring SQL Server 7.0 for replication.