Types of Replication in SqlServer 2000
Divya Parashar
SQL Server 2000 offers three types of replication: snapshot, transactional, and merge.
Use snapshot replication to make a point-in-time distribution of a publication's articles, with all the defined objects and data, to one or more subscribers
Transactional replication uses snapshot replication in order to initialize the data objects on their subscribers. Transactional replication uses snapshot replication in order to initialize the data objects on their subscribers.
Merge.
It allows making autonomous changes to replicated data on the Publisher and on the Subscriber. With merge replication, SQL Server captures all incremental data changes in the source and in the target databases, and reconciles conflicts according to rules you configure or using a custom resolver you create. Merge replication is best used when you want to support autonomous changes on the replicated data on the Publisher and on the Subscriber
Snapshot, merge, transaction