Version-related data conflicts are common with merge replication as updates to the database happen irregularly when there is a connection between the publisher and the subscriber All changes are synchronized by merge agents installed on all servers, and a preconfigured conflict resolution mechanism kicks in to solve any data conflicts. The other methods for replication of SQL databases are snapshot replication and transactional replication.Ī key characteristic of merge replication is that it permits both the primary server (publisher) and the subscriber servers to independently modify the database. Merge replication is a method for copying and distributing data and database objects from one SQL Server database to another followed by synchronizing the databases for consistency.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |