Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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