SQL Server Replication on Linux

APPLIES TO: yesSQL Server (Linux only) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

SQL Server 2019 preview introduces SQL Server Replication for instances of SQL Server on Linux.

Configure replication on Linux with SQL Server Management Studio (SSMS) replication stored procedures.

An instance of SQL Server can participate in any replication role:

  • Publisher
  • Distributor
  • Subscriber

A replication schema can mix and match operating system platforms. For example, a replication schema may include an instance of SQL Server on Linux for publisher and distributor, and the subscribers include instances of SQL Server on Windows as well as Linux.

SQL Server instances on Linux can participate in any type of replication.

  • Transactional
  • Merge
  • Snapshot

For detailed information about replication, see SQL Server replication documentation.

Supported features

For SQL Server 2019 preview the following replication features are supported:

  • Snapshot replication
  • Transactional replication
  • Merge replication
  • Peer-to-Peer replication
  • Replication with non-default ports
  • Replication with AD authentication
  • Replication configurations across Windows and Linux
  • Immediate updates for transactional replication

Limitations

SQL Server 2019 preview does not support the following features:

  • Immediate update subscribers
  • Oracle publishing

Next steps

Configure SQL Server replication on Linux

Sample: Configure SQL Server replication on Linux