Deprecated Features in SQL Server Replication

This topic describes the deprecated Replication features that are still available in SQL Server 2012. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

New Items Deprecated in SQL Server 2012




The RMO API is deprecated. Build new applications using Transact-SQL instead

Heterogeneous replication

Heterogeneous replication to non-SQL Server subscribers is deprecated. To move data, create solutions using change data capture and SSIS.

Oracle Publishing

Oracle Publishing is deprecated. To move data, create solutions using change data capture and SSIS.

Items Deprecated in Previous Versions

Deprecated Features That Affect All Types of Replication

The following features, which apply to all types of replication, are deprecated in SQL Server 2005 or SQL Server 2008.



Attachable subscriptions

This feature can be used when deploying a large number of pull subscriptions, which is common in merge replication. We recommend that you use the following approaches rather than attachable subscriptions:

  • For merge publications that are partitioned using parameterized filters, we recommend that you use partitioned snapshots, which simplify the initialization of a large number of subscriptions.

  • For publications that are not partitioned, you can initialize a subscription with a backup.

In both cases, you can automate the creation of a large number of subscriptions with scripting: create a single subscription; script it; modify the script for each Subscriber; and apply the script at each Subscriber to create a subscription. For more information, see Scripting Replication.

Subscriber registration

The sp_addsubscriber stored procedure is deprecated. It is no longer required to explicitly register a Subscriber at the Publisher.

SQL Distributed Management Objects (SQL-DMO)

Existing code will continue to work, but SQL-DMO does not support new features in SQL Server 2005 and SQL Server 2008. Use Replication Management Objects (RMO) instead. For more information, see Replication Management Objects Concepts.

Schema changes using sp_repladdcolumn and sp_repldropcolumn

The stored procedures sp_repladdcolumn and sp_repldropcolumn have been deprecated. Use schema change replication instead.

The stored procedures cannot be used for adding or dropping columns with data types introduced in SQL Server 2005 and later versions: xml, varchar(max), nvarchar(max), varbinary(max), or user-defined types (UDT), datetime2, time, datetimeoffset, hierarchyid, geometry, and geography types.

Checksum validation

Checksum validation should not be used. Use binary checksum validation. You can also use row count validation for all SQL Server Subscribers, including those subscribing to publications from Oracle Publishers.

Adding publications to Active Directory

Adding a publication to Active Directory using the @add_to_active_directory parameter of sp_addpublication or sp_addmergepublication, has been deprecated. Subscribing to a publication by locating it in Active Directory has been discontinued.

-UseInprocLoader parameter

This parameter of the Distribution Agent and Merge Agent is deprecated because it is not compatible with the XML data type. If you are not replicating XML data, this parameter can be used. For more information, see Replication Distribution Agent and Replication Merge Agent.

PublisherAddress, PublisherNetwork, DistributorNetwork, and DistributorAddress parameters in Distribution and Merge Agents¹

These parameters are used to specify the IP address when connecting to the publisher or distributor. Because the replication subsystem uses server names to verify the connection, we recommend that you use alias at the client protocols to map the IP address to server name and use the server name in the agents.

¹  Deprecated in SQL Server 2008.

Deprecated Features of Transactional Replication

The following transactional replication features were deprecated in SQL Server 2005 or SQL Server 2008.



Subscription expiration for transactional publications

The @retention property of sp_addpublication has been deprecated. Subscriptions are still marked as inactive and must be reinitialized if they have not synchronized within the maximum distribution retention period (the @max_distretention property of sp_adddistributiondb.

"No sync" subscriptions to transactional publications

A subscription is a "no sync" subscription if a value of none is specified for the @sync_type parameter of sp_addsubscription or sp_addpullsubscription. If you want to specify that the necessary schema and data are already present in the subscription database, specify a value of replication support only for the parameter instead.

ODBC Subscribers

Use OLE-DB for non-SQL Server Subscribers instead.

Transformable subscriptions

This feature is available through the stored procedure interface, but support for this feature in the user interface has been dropped. Using the feature requires installation of SQL Server 2000 Data Transformation Services (DTS). For more information, see Integration Services Backward Compatibility.

Distribution ActiveX control

This control allows you to embed the Distribution Agent in applications. Use RMO instead. For more information, see Synchronize a Pull Subscription and Synchronize a Push Subscription.

Replication Distributor Interface

In SQL Server 2000, the Replication Distributor Interface provided an interface to store replicated transactions in the distribution database on the Distributor. This interface could be used to enable publishing from a non-SQL Server database (additional custom programming was required to track changes on the Publisher). Support for this feature has been deprecated, but existing code will continue to work on a server upgraded from SQL Server 2000. For more information, see "Replication Distributor Interface Reference" in SQL Server 2000 Books Online.

Replicating to Oracle 8 subscribers and from Oracle 8 publishers¹

¹  Deprecated in SQL Server 2008.

Deprecated Features of Merge Replication

The following merge replication features were deprecated in SQL Server 2005 or SQL Server 2008.



Alternate synchronization partners

The alternate synchronization partners feature allows you to specify an alternate Publisher with which a Subscriber can synchronize.

In SQL Server 2005 and SQL Server 2008, we recommend that you use merge replication in conjunction with database mirroring, rather than alternate synchronization partners. For more information, see Database Mirroring and Replication (SQL Server).

"No sync" subscriptions to merge publications1

A subscription is a "no sync" subscription if a value of none is specified for the @sync_type parameter of sp_addmergesubscription or sp_addmergepullsubscription. This type of subscription is not recommended for merge replication.

Merge ActiveX control

This control allows you to embed the Merge Agent in applications. Use RMO instead.

Multicolumn UPDATE option

When merge replication performs an update, it updates all changed columns in one UPDATE statement and resets unchanged columns to their original values. Alternatively, it can issue multiple UPDATE statements, with one UPDATE statement for each column that has changed. The multicolumn UPDATE statement is typically more efficient.

In versions of SQL Server prior to SQL Server 2005, we recommend that you specify a value of false for the @fast_multicol_updateproc article option to address cases in which a multicolumn update (one UPDATE statement) might be less efficient:

  • Most updates involve a small number of columns.

  • Index maintenance on unchanged columns is high because those columns are reset when updates occur.

Due to performance improvements in SQL Server, this option is no longer required for these cases.

-ParallelUploadDownload parameter¹

This parameter of the Merge Agent is used to perform simultaneous upload and download of changes in a merge replication session. This parameter provides a performance gain, but it is outweighed by the amount of metadata that must be transferred over the network.

@allow_partition_realignment property in sp_addmergepublication¹

This parameter is used to control the delete operations that must be sent to Subscribers if a row moves out of the Subscriber's partition.

-ExchangeType parameter¹

This parameter is used to control whether the Merge Agent goes through the upload phase or the download phase or both. This defaults to 3 to perform both upload and download. We do not recommend upload-only because it would not replicate schema changes or initialization processes. Download-only functionality can be achieved by using @subscriber_upload_options for an article. For more information, see sp_addmergearticle (Transact-SQL).

@delete_tracking property in sp_addmergearticle¹

This property is used to stop tracking deletes when deletes should be sent down to the Publisher or Subscriber. This can be implemented by using the DeleteHandler in the BusinessLogicModule.

Logical Records¹

This feature is used to send a set of related rows in a single transaction. In most cases, this feature adds significant performance overhead to replication when it is used.

¹  Deprecated in SQL Server 2008.

See Also


Replication Backward Compatibility