Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Permalink
live
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time
title description author ms.author ms.reviewer ms.date ms.topic ms.service ms.subservice monikerRange
SQL Server Replication on Linux
Learn how SQL Server 2017 (14.x) (CU18) and later support SQL Server Replication for instances of SQL Server on Linux.
VanMSFT
vanto
vanto
12/09/2019
article
sql
linux
>=sql-server-2017||>=sql-server-linux-2017

SQL Server Replication on Linux

[!INCLUDE SQL Server - Linux]

[!INCLUDESQL Server 2017] (CU18) and later support 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
  • Snapshot

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

Supported features

The following replication features are supported:

  • Snapshot replication
  • Transactional replication
  • Replication with non-default ports
  • Replication with Active Directory authentication
  • Replication configurations across Windows and Linux
  • Immediate updates for transactional replication

Limitations

The following features are not supported:

  • Merge replication
  • Peer-to-Peer replication
  • Oracle publishing

Next steps

Configure SQL Server replication on Linux

Sample: Configure SQL Server replication on Linux