Skip to main content

SQL Server Replication

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

Transactional replication is typically used in server-to-server scenarios that require high throughput, including: improving scalability and availability; data warehousing and reporting; integrating data from multiple sites; integrating heterogeneous data; and offloading batch processing. Merge replication is primarily designed for mobile applications or distributed server applications that have possible data conflicts. Common scenarios include: exchanging data with mobile users; consumer point of sale (POS) applications; and integration of data from multiple sites. Snapshot replication is used to provide the initial data set for transactional and merge replication; it can also be used when complete refreshes of data are appropriate. With these three types of replication, SQL Server provides a powerful and flexible system for synchronizing data across your enterprise.

Replication Documentation

Replication Resources

SQL Server Replication Downloads

SQL Server 2008 – Replication

SQL Server Replication: Providing High Availability using Database ...
Filename: ReplicationAndDBM.docx3. SQL Server Replication: Providing High Availability using Database Mirroring17. SQL Server Replication: Providing High Availability ... more
Practical SQL Server 2008 for Oracle DBA
SQL Server replication permits propagation of schema alterations as well. Standby Database . In Oracle and SQL Server, the scalability-related function of standby ... more
Microsoft SQL Server Enterprise LOB Application Monitoring with ...
Microsoft SQL Server Enterprise LOB Application Monitoring with System Center Operations Manager 2007 Companies worldwide depend on the Microsoft® SQL Server™ 2005 ... more
Guide to Migrating from DB2 to SQL Server
Guide to Migrating from DB2 to SQL Server SQL Server Technical Article Authors: Yuri Rusakov (DB Best Technologies) , Alexander Pavlov (DB Best Technologies) , Yuri ... more
SQL Server 2008 Failover Clustering
SQL Server 2008 Failover Clustering. SQL Server Technical Article . Writers: Mike Weiner, Paul Burpo, Max Verun, Joseph Sack, Justin Erickson. Contributors: Sanjay ... more