SQL Server Transaction Replication with Always on availability groups to Azure SQL Database

ESatheesh 0 Reputation points
2023-04-25T17:43:21.69+00:00

I have a SQL Server 2017 environment with an always-on availability group setup with three nodes. Two of them are synchronous commits, and one is an asynchronous commit. We have a requirement to configure transactional replication from an always-on (on-prem) publisher to Azure SQL databases as subscriptions. My DB size is Apex 8 TB. Can someone help me with all the steps to complete this setup? Thanks Sathesh

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 33,251 Reputation points MVP
    2023-04-25T19:04:14.44+00:00

    The steps to configure transactional replication between Azure SQL and SQL Server can be found here. Steps to configure transactional replication between SQL Server and Azure SQL Managed Instance can be found here.
    Azure SQL Databases are limited to 4 TB size. Azure Managed Instance General Purpose has a storage limit of 16 TB as explained here. Azure SQL Database can only be a push subscriber.

    0 comments No comments