Replication Options (Enterprise Manager)
Collapse the table of content
Expand the table of content

Replication Options (Enterprise Manager)

SQL Server 2000

Replication Options allow you to configure replication in a manner best suited to your application and environment.

Option Type of Replication Benefits
Filtering Published Data Snapshot Replication

Transactional Replication

Merge Replication

Filters allow you to create vertical and/or horizontal partitions of data that can be published as part of replication. By distributing partitions of data to different Subscribers, you can:
  • Minimize the amount of data sent over the network.

  • Reduce the amount of storage space required at the Subscriber.

  • Customize publications and applications based on individual Subscriber requirements.

  • Reduce conflicts because the different data partitions can be sent to different Subscribers.
Updatable Subscriptions (Immediate Updating, Queued Updating) Snapshot Replication

Transactional Replication

Immediate updating and queued updating options allow users to update data at the Subscriber and either propagate those updates to the Publisher immediately or store the updates in a queue.

Updatable subscriptions are best for replication topologies where replicated data is mostly read, and occassionally updated at the Subscriber when Publisher, Distributor, and Subscriber are connected most of the time and when conflicts caused my multiple users updating the same data are infrequent.

Transforming Published Data Snapshot Replication

Transactional Replication

You can leverage the data movement, transformation mapping and filtering capabilities of Data Transformation Services (DTS) during replication. With transformable subscriptions, you can:
  • Create custom partitions for snapshot and transactional publications.

  • Transform the data as it is being published with data type mappings (for example, integer to real data type), column manipulations (for example, concatenating first name and last name columns into one), string manipulations, and functions.
Alternate Synchronization Partners Merge Replication Alternate synchronization partners allow Subscribers to merge publications to synchronize data with servers other than the Publisher at which the subscription originated. This allows the Subscriber to synchronize data when the original Publisher is unavailable, and is also useful for mobile Subscribers that may have access to a faster or more reliable network connection with an alternate server.
Optimizing Synchronization Merge Replication By optimizing synchronization during merge replication, you can store more information at the Publisher instead of transferring that information over the network to the Subscriber. This improves synchronization performance over a slow network connection, but requires additional storage at the Publisher.
Attachable Subscription Databases Snapshot Replication

Transactional Replication

Merge Replication

Attachable subscription databases allow you to transfer a database with replicated data and subscriptions from one Subscriber to another. After the database is attached to the new Subscriber, the database at the new Subscriber will automatically receive its own pull subscriptions to the publications at those Publishers. This saves you the time and effort of creating subscription databases and subscriptions at multiple Subscribers.

© 2015 Microsoft