Implementing Replication (Enterprise Manager)

How to Install SQL Server 2000

How To

Implementing Replication (Enterprise Manager)

Whether you are using snapshot replication, transactional replication, or merge replication, the following stages will help you implement replication.

Stage Tasks
Configuring Replication Identify the Publisher, Distributor, and Subscribers in your topology. Use SQL Server Enterprise Manager, SQL-DMO, scripts, or Transact-SQL system stored procedures to configure the Publisher, create a distribution database, and enable Subscribers.
Publishing Data and Database Objects Create the publication and define the data and database object articles in the publication, and apply any necessary filters to data that will be published.
Subscribing to Publications Create push, pull, or anonymous subscriptions to indicate what publications need to be propagated to individual Subscribers and when.
Applying the Initial Snapshot Indicate where to save snapshot files, whether they are compressed, and scripts to run before or after applying the initial snapshot.

Specify to have the Snapshot Agent apply the snapshot at the Subscriber immediately after creating a subscription or at a specified time.

Apply the snapshot manually by saving it to a network location or to removable media that can be transported to the Subscriber, and then applying the Snapshot files manually at the Subscriber.

Synchronizing Data Synchronizing data occurs when the Snapshot, Log Reader, or Merge Agent runs and updates are propagated between Publisher and Subscribers.

For snapshot replication, the snapshot will be reapplied at the Subscriber.

For transactional replication, updates will be propagated to Subscribers.

If using updatable subscriptions with either snapshot replication or transactional replication, data will be propagated from the Subscriber to the Publisher and to other Subscribers.

For merge replication, data is synchronized during the merge process when data changes at all servers are converged and conflicts, if any, are detected and resolved.