Discontinued Functionality in SQL Server 2005 Replication

SQL Server Setup

Updated: 14 April 2006

This topic describes replication features that have been discontinued in Microsoft SQL Server 2005.

Note:
This topic is available in the Setup Help documentation and in SQL Server 2005 Books Online. Topic links that appear as bold text in the Setup Help documentation refer to topics that are only available in Books Online.

Discontinued Features That Affect All Types of Replication

The following replication features have been discontinued in SQL Server 2005.

Feature Description

Creating push subscriptions without a connection to the Subscriber in the New Subscription Wizard

Creating push subscriptions in the New Subscription Wizard now requires an active connection to the Subscriber during configuration. For more information about using the wizard, see How to: Create a Push Subscription (SQL Server Management Studio).

Using file transfer protocol (FTP) to initialize Subscribers running SQL Server version 7.0

This feature is available for Subscribers running SQL Server 2000 or later versions. For more information, see Transferring Snapshots Through FTP.

Creating subscriptions in Windows Synchronization Manager

You can no longer create subscriptions in Synchronization Manager, but you can still synchronize subscriptions. For more information, see Windows Synchronization Manager.

Subscribing to a publication by locating it in Active Directory

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

Snapshot ActiveX control

This control allows you to embed the Snapshot Agent in applications. Use the new managed Snapshot Agent instead. For more information, see SnapshotGenerationAgent and How to: Create the Initial Snapshot (RMO Programming).

Remote agent activation

SQL Server 2000 supported running the Distribution Agent or Merge Agent on another computer and then activating that agent remotely using DCOM. Support has been discontinued for Distributors running SQL Server 2005 and later; it has been deprecated for Distributors running earlier versions of SQL Server. For more information, see "Remote Agent Activation" in SQL Server 2000 Books Online.

Microsoft Access (Jet 4.0) Subscribers

Jet is the underlying database used by Access, and replication supported subscriptions to Jet databases in SQL Server 2000. These subscriptions are no longer supported.

We recommend using Microsoft SQL Server 2005 Express Edition instead. Access can use a SQL Server database as a backend, and SQL Server databases are not affected by this issue. For more information, see Replicating Data to SQL Server Express.

Discontinued Transactional Replication Features

The following transactional replication features have been discontinued in SQL Server 2005.

Feature Description

Microsoft Message Queuing (MSMQ) option for queued updating subscriptions

With queued updating subscriptions, changes from Subscribers are written to a queue; changes are then read from the queue and delivered to the Publisher by the Queue Reader Agent. In SQL Server 2000, subscriptions could use a SQL Server queue or MSMQ to queue changes. The type of queue was specified with the @queue_type parameter of sp_addpublication (Transact-SQL), which allowed values of sql and msmq. In SQL Server 2005, only a value of sql is allowed. Existing publications that use MSMQ are modified during upgrade to use a SQL Server queue. If you have applications that depend on queued updating using MSMQ, these applications will need to be rewritten to accommodate a SQL Server queue. For more information about queued updating subscriptions, see Updatable Subscriptions for Transactional Replication.

Discontinued Merge Replication Features

The following merge replication features have been discontinued in SQL Server 2005.

Feature Description

Publishing from SQL Server 2005 Express Edition

SQL Server MSDE could serve as a Publisher for merge publications. SQL Server Express, the replacement for MSDE, cannot serve as a Publisher. It can subscribe to merge, transactional, and snapshot publications. Merge replication, and transactional replication with updating subscriptions, both allow changes to be propagated from Subscribers back to the Publisher. For more information about replicating to SQL Server Express, see Replicating Data to SQL Server Express.

IVBCustomResolver interface

This interface allowed you to write COM-based custom conflict resolvers in Visual Basic. In SQL Server 2005, we recommend using Business Logic Handlers rather than COM-based resolvers. For more information, see Executing Business Logic During Merge Synchronization.

You can still write COM-based resolvers in C++. For more information, see COM-Based Custom Resolvers.

See Also

Concepts

Replication Backward Compatibility

Other Resources

Replication Enhancements