What are the different types of replication? How are they used?
- 3 Answers
- 12309 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
What do you need to connect php to sql server?
Would you store your query in a ssrs report or a database server? State the reason why?
When does a workload on SQL Azure get throttled?
What is update_statistics command?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Explain about Normalization?
Do you know what is normalization of database? What are its benefits?
Define model database?
How do I delete a sql server database?
How many types of keys are there?
What are the differences between sql server and mysql.
Why do we use non clustered index?
What is stored procedures?
What are the different types of triggers in SQL SERVER?
Explain datetime2 data type in sal server 2008?
