O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Transactional replication to the rescue

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:

  • Publisher: This is the source database. It is where we need to replicate the data from. Your other data store is not SQL Server? No problem! You can use an Oracle database as a source.
  • Subscriber: This is the recipient or the target database. A subscriber can turn ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required