Now, we can eliminate the need for merging by implementing transactional replication. What we can accomplish with transactional replication is to propagate the changes in the source database (publisher) to the target database (subscriber) in near real time.
To understand how replication works in SQL Server, think about how a newspaper publication works. Replication actually uses the metaphor in publishing.
Here are the main components of replication: