In Features for SQL Server 2016, I see that Transactional replication to Azure is supported for Web edition. Following the instructions leads to Configure Publishing and Distribution

In attempting to create the publication, I get This edition of SQL Server cannot act as a Publisher or Distributor for replication., which is expected as my server is Web edition.

So how do I set up Web edition replication to Azure SQL, given that it is a supported feature?


According to Xiaochen Wu (Senior Program Manager at Microsoft), there is an error in the documentation. Web edition does not support transaction replication to Azure SQL.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.