What is merge replication?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is merge replication?
Rating:
Merge replication starts with a snapshot of the Publication database. Triggers track the modifications in the data and the schema at the Publisher or the Subscriber server. Merge replication is performed in a server to client environment. It should be performed to fulfill the following conditions:
- When same data is to be updated by multiple Subscribers.
- When data changes are to be propagated to the Publisher and other Subscribers.
- When offline data changes are to be synchronized on the Publisher and other Subscribers.
- When conflicts are to be detected and resolved.
- When each Subscriber needs different partitions of data.
Rating:
Was this information helpful?
Other articles
- What is sys.dm_db_index_physical_stats DMV?
- What is SQL Server Profiler?
- What is SYS.DM_EXEC_QUERY_STATS DMV?
- What is the Physical Disk Avg Disk Queue Length counter?
- What is a package checkpoint?