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.