O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

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

Chapter 22. Transactional Replication

Whenever someone tells me that adopting their beliefs could give me the same type of life they have, I tell them that that's exactly what I'm afraid of.

—H. W. Kenton

Transactional replication is by far the most widely used form of SQL Server replication. It combines a good deal of functionality with reasonably simple configuration and administration. It's more full-featured than snapshot replication but much easier to set up and manage than merge replication.

One mistake I often see people make when deciding which type of replication to go with is not realizing that both snapshot replication and transactional replication offer immediate and queued updating subscriptions. People somehow get the idea that ...

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