What's New (Replication)
SQL Server 2012 introduces several new features and improvements to replication.
The AlwaysOn Availability Groups feature is a high-availability and
disaster-recovery solution that provides an enterprise-level alternative to
database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups
maximizes the availability of a set of user databases for an enterprise.
An availability group supports a failover environment for a discrete set of user
databases, known as availability databases, that fail over together.
Replication supports the following features on Availability groups:
- A publication database can be part of an
availability group. The publisher instances must share a common distributor.
Transaction, merge, and snapshot replication are supported.
- In an AlwaysOn Availability Group an
AlwaysOn secondary cannot be a publisher. Republishing is not supported when
replication is combined with AlwaysOn.
- Peer-To-Peer (P2P), bi-directional,
reciprocal transactional publications, and Oracle Publishing are not
supported.
- A database that is enabled for Change Data
Capture (CDC) can be part of an availability group.
- A database enabled for Change Tracking
(CT) can be part of an availability group.
Four new stored procedures provide replication
support for AlwaysOn.
- sp_redirect_publisher (Transact-SQL)
- sp_get_redirected_publisher (Transact-SQL)
- sp_validate_redirected_publisher
(Transact-SQL)
- sp_validate_replica_hosts_as_publishers
(Transact-SQL)
Support for 15,000 Partitions
Replication supports up to 15,000 partitions for tables and indexes.
Thanks for reading this article