Uses of Replication

There are a number of applications for replication, including sales data distribution and collection, pricing distribution, offloading of reports, and more. Since replication takes a database or subset of a database and keeps it up-to-date on another server, the uses are quite extensive. Uses of replication can include:

  • Scaling out applications

  • Data warehousing

  • Distributing and consolidating data from satellite locations

  • Offloading report processing

Let’s look at some of these uses of replication.

Scaling Out Applications

Application scaling is usually defined as either scale up or scale out. Scale up refers to a single server that can support larger and more processors. As you add more resources to the server, the performance increases. ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial