What is 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.
Replication
is the process whereby data is copied between databases on the same server or
different servers connected by LANs, WANs, or the Internet. Microsoft SQL
Server replication uses a publish, distributor and subscribe metaphor.
Types of Replication in Sql Server
- 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.
In this small blog i have explained brief about the replication ,i hope this blog is useful for all readers ,if you have any suggestion thgen please contact me.