The performance and availability problems associated with remote database access can be solved by replicating the data from its source database to a local database. Replication Server provides a cost-effective, fault-tolerant system for replicating data.
Replication Server keeps data up to date in multiple databases so that clients can access local data instead of remote, centralized databases. Compared to a centralized data system, a replication system provides improved system performance and data availability and reduces communication overhead.
Because it transfers transactions, not rows, Replication Server maintains the integrity of replicated data across the system, while also increasing data availability. Replication Server also allows you to replicate stored procedure invocations, further enhancing performance.
