3

We have a running production using SQL-Server 2014 in production. It has replication running and partial subscribers in several data centers. I had a request to evaluate SQL Server 2017 on Linux so it could serve for a new application running on Linux. The issue is that it should be a subscriber as well and seems that Microsoft doesn't have replication in development yet.

Have someone already handled this issue of replication in any way?

Is Replication supported in SQL Server on Linux?

I opened a connect and perhaps some of you would vote for it.

Thanks in advance

6

At the moment, replication is not supported on Linux. However, according to the release notes, replication support will be added in a future release.

Release notes for SQL Server 2017 on Linux

  • Thanks for the link. I actually understood from it before that they are unsure if it will be added. But seems that you are right. – Liya Tansky Nov 28 '17 at 8:28
  • I expect it to be added soon but I'm unsure what the timeline is. Hopefully someone from Microsoft will comment on your Connect item and let us know. – Brandon Williams Nov 28 '17 at 17:29
  • Is this now available? – MateodelNorte Sep 18 '18 at 22:02
2

It is available with SQL 2019 preview - SQL Server Replication on Linux

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.

It does have some limitations still compared to the Windows version of the product though:

SQL Server 2019 preview does not support the following features:

  • Immediate update subscribers
  • Oracle publishing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.