What's New in Replication of SQL server 2012

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

Ebook Download
View all
View all