Share via

Does SQL Server Standard Edition support Transactional replication ?

MS Techie 2,751 Reputation points
2021-03-15T16:50:06.867+00:00

I am trying to perform transactional replication from SQL on Azure VM (IaaS) to Azure SQL DB (PaaS).

Does SQL Server Standard Edition support Transactional replication ?

From what edition of SQL Server , is transactional replication supported ?

Azure SQL Database
SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2021-03-15T22:41:02.293+00:00

    See here: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15

    Standard Edition supports Transactional Replication. Lower editions can only be subscribers.

    0 comments
  2. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2021-03-16T01:38:50.213+00:00

    Hi @MS Techie ,

    >Does SQL Server Standard Edition support Transactional replication ?

    Yes, it is supported as below screenshot.

    77987-screenshot-2021-03-16-093619.jpg

    Quote from MS document.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.