| title | SQL Server Replication on Linux | Microsoft Docs |
|---|---|
| description | This article describes SQL Server replication on Linux. |
| author | MikeRayMSFT |
| ms.author | mikeray |
| manager | craigg |
| ms.date | 03/20/2018 |
| ms.topic | article |
| ms.prod | sql-non-specified |
| ms.prod_service | database-engine |
| ms.service | |
| ms.component | |
| ms.suite | sql |
| ms.custom | sql-linux |
| ms.technology | database-engine |
| ms.assetid | |
| ms.workload | On Demand |
| monikerRange | >=sql-server-ver15||>=sql-server-linux-ver15||=sqlallproducts-allversions |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-linuxonly]
[!INCLUDEsqlservervnext] CTP 2.0 introduces SQL Server Replication for instances of SQL Server on Linux. At this time, SQL Server Replication on Linux is a preview feature.
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 can use instances of SQL Server on Linux for publisher and distributor, and the subscribers can include instances of SQL Server on Windows.
SQL Server instances on Linux can participate in any type of replication.
- Transactional
- Merge
- Snapshot
For [!INCLUDEsqlservervnext] CTP 2.0 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
[!INCLUDEsqlservervnext] CTP 2.0 does not support the following features:
- Immediate update subscribers