Merge ReplicationWith snapshot and transactional replication, a single source of data exists from which all the replication targets are replenished. In some situations, it might be necessary or desirable to allow the replication targets to accept changes to the replicated tables, and merge these changes together at some later date.Merge replication allows data to be modified by the subscribers and sychronized at a later time. This could be as soon as a few seconds or a day later.Merge replication can be helpful for a sales database that is replicated from a central SQL Server box out to several dozen sales laptops. As the sales personnel make sales calls, they can add new data to the customer database or change errors in the existing data. When the salespeople return to the office, they can synchronize their laptops with the central database. Their changes are submitted, and the laptop gets refreshed with whatever new data was entered since the last sycnhronization.合并复制与快照复制和交易,单一来源的数据存在,从所有复制的目标是充实。在某些情况下,可能有必要或可取的,让复制目标,以接受更改复制表和合并这些变化一起在一些较后的日期。合并复制允许数据进行修改,由用户和sychronized在稍后的时间。这可能是尽快在几秒钟或一天后。合并复制可以帮助销售数据库,是复制,从一个中央的SQL Server框中,以几十个销售笔记型电脑。作为销售人员,使销售通话,他们可以添加新的数据传送到客户数据库或变更错误的,在现有的数据。当销售人员回到办公室,他们可以同步他们的笔记型电脑与中央数据库。他们的变化,提交,和笔记型电脑得到更新与新的数据,无论是进入了自上次 sycnhronization 。