Does SQL Server Standard Edition support Transactional replication ?

MS Techie 2,686 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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,270 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 106K Reputation points MVP
    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 No comments

  2. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    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.