RMO API deprecated in SQL Server 2012

RMO API deprecated in SQL Server 2012 by Brandon Williams

Active

Type:	Suggestion
ID:	774485
Opened:	12/16/2012 1:05:51 PM
Access Restriction:	Public

Workaround(s)

view

According to Deprecated Features in SQL Server Replication - New Items Deprecated in SQL Server 2012:

http://msdn.microsoft.com/en-us/library/ms143550.aspx

RMO

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

As you can see at the bottom of the document in Community Additions, there have been several people who have objected to the RMO API deprecation.

Many people use the RMO API for programming the various replication agents. It would be devastating to deprecate this feature.

I am requesting that the deprecation of the RMO API be reconsidered.

Details (expand)

English

Replication

Do not deprecate the RMO API.

Faster Development

-Improved Administration
-Improved Installation

Many people use the RMO API for programming the various replication agents. It would be devastating to deprecate this feature.

0 attachments

Posted by brianWakhutu on 3/19/2013 at 1:21 AM

I have user RMO for the last three projects that i have done using SQL server's replication in 2005 and 2008 versions, i have to say that for remote data collection applications like the sample replication application that comes on the tutorials page, i prefer using RMO for users to sync data other than the Transact SQL kindly reconsider the Deprecation of this feature as it has been really a good feature when developing field applications that use SQL server Replication

Posted by Microsoft on 1/4/2013 at 4:33 PM

Hi Brandon Williams ,

thanks for taking the time to share your feedback, this is really important to us.
We will investigate the issue and get back to you.

Best regards
Jean-Yves Devant
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server

Posted by Bob Beauchemin on 12/16/2012 at 1:49 PM

In addition, because replication is asymmetric (different roles on different machines) and multi-machine, RMO/PowerShell is a nice way to configure it as opposed to GUI or multi-machine T-SQL.