Replication Model

SQL Server version 7.0 replication builds on the "publish and subscribe" model introduced in SQL Server version 6.0. The model consists of Publishers, Subscribers and Distributors, publications and articles, and push and pull subscriptions. Four new intelligent agents-Snapshot Agent, Log Reader Agent, Distribution Agent, and Merge Agent-manage the SQL Server 7.0 replication process. All agents can run under the SQL Server Agent and can be fully administered using SQL Server Enterprise Manager. The Snapshot and Log Reader Agents execute on the Distributor server, while the Distribution and Merge Agents execute on the Distributor server for push subscriptions, and on the Subscriber server for pull subscriptions. SQL Server replication is built on OLE DB and ODBC, the industry standards for data access, providing rich interoperability with a wide variety of relational and nonrelational data sources.