question

glandry avatar image
glandry asked

Can you have Merge Replication to an Always on cluster

I have a merge publication on a single server node and I need to replicate to a subscriber in an AGC. I set up the subscriber pointing to the listener but validation says "there is no subscription." Is this even possible?

replicationalways-onsubscriptionssubscription
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered

Setting up availability group as subscriber is only supported for transactional replication. For merge replication you have to setup the active node as subscriber and after a failover you have to configure the new active node as subscriber.

From this documentation:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/replication-subscribers-and-always-on-availability-groups-sql-server?view=sql-server-ver15

What is Supported

SQL Server replication supports the automatic failover of the publisher and the automatic failover of transactional subscribers. Merge subscribers can be part of an availability group, however manual actions are required to configure the new subscriber after a failover. Availability Groups cannot be combined with WebSync and SQL Server Compact scenarios.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

glandry avatar image glandry commented ·

Thanks @Magnus Ahlkvist

. I suspected as much. Transnational works just fine.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.