Click to Rate and Give Feedback
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All

Want more? Here are some additional resources on this topic:

SQL Server 2005 Books Online (November 2008)
Replication Enhancements

Microsoft SQL Server 2005 introduces a significant number of new features and improvements to replication.

These are the areas in which replication has been enhanced.

Topic Description

Replication Security Enhancements

The replication security model has changed, allowing more control over the accounts under which replication agents run and make connections.

Replication Manageability Enhancements

Manageability enhancements include: improvements to the user interface, including a new Replication Monitor; easier management of tables with identity columns; the ability for transactional subscriptions to be initialized from a backup; easy-to-manage snapshots for merge publications with parameterized filters.

Replication Availability Enhancements

Availability enhancements include: the ability to make schema changes to published tables; peer-to-peer transactional replication; the ability to group changes to related rows in merge replication.

Heterogeneous Replication Enhancements

Heterogeneous replication enhancements include: publishing data from an Oracle database with transactional and snapshot replication; improved support for non-SQL Server Subscribers.

Replication Programmability Enhancements

Replication has a new managed code programming model: Replication Management Objects (RMO); merge replication allows you to introduce custom business logic into the synchronization process.

Replication Mobility Enhancements

Merge replication provides the ability to replicate data over HTTPS with the Web synchronization option.

Replication Scalability and Performance Enhancements

Scalability and performance enhancements include: significant improvements to the performance of filtered merge publications; the ability of the Distribution Agent in transactional replication to apply batches of changes in parallel to a Subscriber.

Enhancements for Updatable Transactional Subscriptions

Updatable Transactional Subscriptions can now handle updates to large data types at Subscribers.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker