Transactional Replication And SQL On Linux

Phil Grayson shows a way to get transactional replication working on Linux:

Microsoft have stated that transactional replication isn’t supported on Linux and we’re not sure if they intend to in the future. This means that if you try to add the server to a publisher, you get the following message. So you can’t use the GUI and it also means that you can’t use pull as the necessary files won’t be there.

Despite that warning, there is a way to set up a push subscription; click through for that way.

Related Posts

Tips For SQL Server On Linux + Docker

Kellyn Pot’vin-Gorman has a set of tips for working with SQL Server on Linux using Docker: Easy Download Docker is available for Mac and Windows with a simple installation by the defaults. Download the correct installation for your OS type. Run the installer and keep all the defaults, choosing Linux containers, not Windows containers Reboot […]

Read More

SSL Provider Error: 31 With SQL Server In Docker

Andrew Pruski walks us through fixing a connection error: I recently bought a Dell XPS 13 running Ubuntu 16.04 and ran into an issue when connecting SQL Operations Studio (version 0.31.4) to SQL 2017 CU9 running in a docker container. Other people seem to encountering this issue as well so am posting it so that […]

Read More

2 Comments

  • Gary on 2017-09-25

    Is this really possible? If so, I would like to know how

    • Kevin Feasel on 2017-09-26

      I just fixed the link; Phil shows the way to do it. You have to use T-SQL statements rather than the GUI and because it’s not officially supported, you can’t do pull subscription. But it’s possible to get a push subscription working.

Comments are closed

Categories

September 2017
MTWTFSS
« Aug Oct »
 123
45678910
11121314151617
18192021222324
252627282930