We got a requirement to replicate data between two different HA Clusters.

---Current Prod Environment-------

SQL Server 2016 Servers

HADR Cluster 1 (HA1) - Primary Replica (PR1), Secondary Replica (SR1) and DR Replica (DR2)

HADR Cluster 2 (HA2) - Primary Replica (PR2) and DR Replica (DR2)

---Current Prod Environment-------

We need to replicate some tables from an AG Database (DB1) in PR1 to another AG Database (AG2) in PR2.

Current there is a bcp script that runs daily once and they need live data, hence we are planning for Transactional Replication between HA1 and HA2 Clusters ( from DB1 -> DB2)

It would be really helpful, if I could get some pointers to any documentation, best practices, Pros and Cons for setting up Tran Replication between two AlwaysOn Clusters. Or any other best method? Thanks.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.