Looking for a way to manage ARS replication roles using powershell | Standalone Publisher Subscriber

Question

I found this to promote using powershell but does not talk about transitioning to other roles: https://support.oneidentity.com/active-roles/kb/311101/how-to-promote-an-active-roles-publisher-using-powershell 
 Please advise if this is even possible using powershell and if so I'd appreciate some pointers. 
 Thanks,

Terrance.Crombie · Accepted Answer

I'll chime in: 
 No: there is no easy method using the Active Roles Management Shell to trigger change a SQL publisher to a subscriber or vice-versa. 
 This is not possible for a number of reasons, but most importantly: 
 Microsoft SQL doesn't support any easy method to change roles when using SQL Merge Replication. A publisher is a publisher and a subscriber is a subscriber until a DBA breaks replication and re-creates it in a different configuration. This is an impactful change and not a simple change of roles. If not done properly, there is a high risk of data loss. 
 In simple terms, SQL Merge Replication does not offer any real-time redundancy options for the Publisher. If the Publisher is down, changes can be committed into the Subscriber databases and will only be replicated when the Publisher has been restored or when the DBA has manually intervened.

Looking for a way to manage ARS replication roles using powershell | Standalone < > Publisher < > Subscriber

Top Replies