O'Reilly logo

Tribal SQL by Matt Velic, David Tate, Shaun J Stuart, Wil Sisney, Mark S Rasmussen, Bob Pusateri, Dev Nambi, Colleen Morrow, Stephanie Locke, Chuck Lathrope, Tara Kizer, Kevin Feasel, Diana Dee, John Barnett, Dave Ballantyne

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

Taming Transactional Replication

Chuck Lathrope

SQL Server Replication is a set of technologies that allows us to copy our data and database objects from one database to another, and then keep these databases in sync by replicating any data changes from one to the other. We can replicate the changes in near real-time, bi-directionally, if required, while always maintaining transactional consistency in each database. In a typical case, we might offload a reporting workload from our primary server (the Publisher, which produces the data) to one or more dedicated reporting servers (Subscribers). After the initial synchronization, we can replicate the data in near real-time; in the best cases, replication can offer a transit latency of just a ...

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