Product: | Syniti Data Replication, DBMoto |
Version: | Syniti Data Replication 9.6 and above, DBMoto 9 and above |
ID: | 3016 |
Summary: | Setting up Syniti DR/DBMoto in a SQL Server AlwaysOn Environment |
SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3 introduced support for replication distribution database in an Availability Group. To correctly configure publisher and distributor:
- When the publisher DB is part of an AG and the distribution DB is a remote stand-alone instance, refer to MSSQLServer-AlwaysOn-DBMoto9.pdf.
- When the Microsoft SQL Server database is part of an Always On Availability Group and the distribution database is also part of an Availability Group, refer to SQLServer-SDR97-AlwaysOn-SetupNotes.pdf.