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?
Answer by Magnus Ahlkvist ·
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:
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.