Typical Uses of Replication

SQL Replication

Replication

Typical Uses of Replication

Microsoft® SQL Server™ 2000 replication supports the distributed environment of increasingly global and mobile corporate operations. Replication allows you to share information across heterogeneous platforms and databases and then modify and reconcile that information. Replication ensures that correct data will be available when and where it is needed.

Replication is used for a variety of applications:

  • Reporting, decision support, and data warehousing applications.

  • Online and offline applications.

  • Web-based applications with many users browsing data.

  • Keeping data close to users (providing more site autonomy and efficient network usage).