Transactional Replication in SQL Server on Linux

In this video, we will briefly cover the various forms of replication available in SQL Server, as well as what is in SQL Server on Linux. Then, we will create a simple publication and subscription using T-SQL.
LINKS AND INFO
Catallaxy Services - www.catallaxyservices.com
Get the command line operations used in this video -- 36chambers.wordpress.com/2024...
Types of Replication -- learn.microsoft.com/sql/relat...
SQL Server replication on Linux -- learn.microsoft.com/sql/linux...
Configure Replication with T-SQL -- learn.microsoft.com/sql/linux...
ReplTalk: All about Microsoft SQL Replication -- repltalk.com/
Setting up transactional replication using T-SQL -- www.sqlservercentral.com/blog...

[@FaizanFastian23]

Hi Kevin. Do you have a complete training series on SQL server for Windows?

[@KevinFeasel]

Not as such, no. I do have a couple playlists that are potentially relevant, though:
- SQL Server installation and configuration: ruclips.net/p/PLeWL8zChJ2us9eZJJl0RJd1i0kwFg9Mjs
- Writing queries in SQL Server: ruclips.net/p/PLeWL8zChJ2usuvVEHGl2BykCQ6SaiZgrW
I do have some ideas on my backlog for future videos, but if there are any particular topics of interest, let me know and I'll see what I can do.

[@FaizanFastian23]

I basically wanna go through MSSQL server on windows covering full tutorial from installation to the end. The current playlist of linux (though short but pretty clear) is excellent. Following this playlist, I have setup the availability group which works perfect. What's missing is availability group using pacemaker, which would have been great had you added that. Anyways excellent work you are doing and I am looking forward for a complete DBA training using MSSQL on windows.

[@KevinFeasel]

@@FaizanFastian23 That's fair enough. I can certainly add it to the backlog. It'd be a longer-term project, so no hard dates on anything, but would be something in the channel's wheelhouse.

[@HusseinSaeed-ex7pm]

Hey Kevine, great vide, i'm trying to rid of windows so i'm using SQL for linux i'm running SQL on docker using ubuntu , is there any way to implement merge replication, i'm using SSMS 18 , i'm already implement it on windows and it is working

[@KevinFeasel]

Merge replication is not supported on Linux, no. Merge replication tends to be something of a laggard for most features. You'll see transactional and snapshot replication support in a variety of features but merge and peer to peer are much less likely to be supported when new things come out, including SQL Server on Linux.
learn.microsoft.com/en-us/sql/linux/sql-server-linux-replication?view=sql-server-ver16#supported-features

[@HusseinSaeed-ex7pm]

@@KevinFeasel so can i set Bidirectional Transactional Replication on Linux , I want the subscriber pull the data from the publisher and in some times subscriber can make some changes , i want to move out of windows to use linux and docker container

[@KevinFeasel]

@@HusseinSaeed-ex7pm This is where the documentation gets a little tricky. There's nothing saying you *cannot* use bidirectional transactional replication, but there's also nothing explicitly saying you *can*. I haven't tried the scenario, to be honest, so I don't know whether that's possible. I'd recommend trying it out to see. If you made me give my prior probability on success, I'd say about 30% chance of success, as it's a more complicated replication scenario than normal transactional replication and unless there were Microsoft customers clamoring for support of that particular feature, it'd probably be low on their implementation list. But there is a chance bidirectional replication came "for free" with the normal transactional replication code--the only way to know for sure is to try it and see if it works.