Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of replication? How are they used?
- 3 Answers
- 13267 Views
- I also Faced
- E-Mail Answers
Answer Posted / raghuram
Replication is a process of copying/moving data between
databases on the same or different servers.In Replication,
We have Three server.
a) Publisher : It is the Principal server
b) Distributor : It sends the data from
Publisher to Subscriber
c) Subscriber : It is the secondary server
which stores the received data
The types of Replication are,
a) Snapshot Replication : It distributes data
exactly as it appears at a specific moment in time and does
not monitor for updates to the data. It is the best used
method of replicating data that changes infrequently or
where the most up-to-date values are not requirement. When
synchronization occurs, the entire snapshot is generated
and sent to the subscribers.
b) Merge Replication : It is the process of
distributing data from Publisher to subscriber, allowing
the Publisher and Subscriber to make update data while they
are connected or disconnected, and then merging the updates
between sites when they are connected.
c) Transactional Replication : An initial snapshot
of data is applied to subscriber, and when data
modifications are made at the publisher, the individual
transactions are captured and propogated to subscriber.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Is sql server is free?
What is the stuff?
Can we add an identity column to decimal datatype?
Can two tables have the same primary key?
How many ways to create table-valued functions?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to list all dsn entries on your local machine using odbc_data_source()?
Explain filestream storage of sql server 2008?
What does <> symbol mean?
How to assign new column names in a view?
What happens when the SQL Azure database reaches Max Size?
What is a linked server in sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Explain SSRS Architecture?
