Replication Overview and Terminology

As stated earlier, SQL Server 2000 has added many new enhancements to data replication. This chapter focuses on introducing you to SQL Server replication terminology and the different types of replication. Additionally it shows you how to perform standard administrative tasks such as creating a distribution database. The next two chapters will get into more detail as they walk you through transactional, merge, and snapshot replication. To become familiar with replication terminology, consider the replication scenario shown in Figure 27.1. With transactional replication, the publication is modified at the publisher's site and the changes are replicated to the subscribers of the publication.

Figure 27.1. Overview ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.