Replication Enhancements
Microsoft SQL Server 2005 introduces a significant number of new features and improvements to replication.
Enhanced Replication Capabilities
These are the areas in which replication has been enhanced.
| Topic | Description |
|---|---|
The replication security model has changed, allowing more control over the accounts under which replication agents run and make connections. |
|
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. |
|
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 include: publishing data from an Oracle database with transactional and snapshot replication; improved support for non-SQL Server Subscribers. |
|
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. |
|
Merge replication provides the ability to replicate data over HTTPS with the Web synchronization option. |
|
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. |
|
Updatable Transactional Subscriptions can now handle updates to large data types at Subscribers. |
See Also
Concepts
Other Resources
Replication Backward Compatibility
SQL Server Replication