I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server Web Edition I wasn't able to configure distribution on premises server I am getting this error related to MSSQL 'web edition'

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.

Noting that the article doesn't say the web edition is not supported. So I assume either the article is wrong or there is something else I am missing. I would appreciate if someone has a solution for this issue (on web edition) online migration

  • Welcome to DBA stack exchange, would you please provide us with more details. – Ahmad Abuhasna Jul 4 '19 at 6:17
  • 1
    The article has an error stating that any edition can be used. Web Edition for SQL Server does not support transnational replication to Azure. You can submit an issue at the bottom of that article to bring it to the team's attention and they can update the article. – user507 Jul 4 '19 at 7:23
  • Why not backup the database to Azure Blob storage and then use this link to restore. – Shanky Jul 4 '19 at 11:15
  • Hi Shawn the article is wrong .. the Web Edition doesn't support duplication .. – Ibrahim Magdy Jul 16 '19 at 6:44

Your Answer

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

Browse other questions tagged or ask your own question.