From: "Wetmore, Matthew (CTR)" <Matthew.Wetmore@express-scripts.com>
To: Scott Ribe <scott_ribe@elevated-dev.com>,
        Erik Serrano
	<eserranos@gmail.com>
CC: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thread-Topic: [EXTERNAL] Re: Is a PS - MSSQL Logical Replication Possible??
Thread-Index: AQHZvixcQCT3xXeU4kOY09kLIZF3uq/Jtj0AgACkqACAAKbiAIAAA6kA///PkaA=
Date: Tue, 25 Jul 2023 18:54:14 +0000
Message-ID: <d5ea09e054ef41359113f81d33d72cf4@express-scripts.com>
References: 
 <CA+dvXXsVdVmeYAsi-DwgEPEchizTb1BA=DcXkfpCv3VkdNVzzg@mail.gmail.com>
 <CAK50Jrz0j8tE3u06O3ACFJBL+0SQDY0Yf+tOd0ESKRuE4GUtPw@mail.gmail.com>
 <CA+dvXXso=++=3TAEdvrJPWEWLOgu2ShB7Ow0ToA6ynyoBBGDcQ@mail.gmail.com>
 <CAF5PJVy8=60ydga=nvPP6WtkOoA-UQ9SFOiowkRNgBv_UdF__A@mail.gmail.com>
 <CA+dvXXv7Q9heXqMeX9pGRL9MR-=TnGYKMdpkDH+6U0OyXdp51Q@mail.gmail.com>
 <FFC2DF15-8C94-428C-BB92-DA75350559FB@elevated-dev.com>
In-Reply-To: <FFC2DF15-8C94-428C-BB92-DA75350559FB@elevated-dev.com>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Subject: Is a PS - MSSQL Logical Replication Possible??
Archived-At: 
 <https://www.postgresql.org/message-id/d5ea09e054ef41359113f81d33d72cf4%40express-scripts.com>
Precedence: bulk

Correct, and with dblink on logical slots.  The gotcha is making the logica=
l slots persistent in your network config.

I have done db link from one table to another on my primary and then use th=
at table as the source for processing data or whatever.

But you will have to do custom work.

The most annoying part of this is the MSSQL ::Postgres inconsistencies such=
 as date, numeric and float , bit::bool types.

-----Original Message-----
From: Scott Ribe <scott_ribe@elevated-dev.com>=20
Sent: Tuesday, July 25, 2023 10:42 AM
To: Erik Serrano <eserranos@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: [EXTERNAL] Re: Is a PS - MSSQL Logical Replication Possible??

> On Jul 25, 2023, at 11:29 AM, Erik Serrano <eserranos@gmail.com> wrote:
>=20
> What you indicate is interesting, I am going to find out about the debezi=
um and attunity programs.
> Thank you very much for answering

I don't know how those two are implemented--but for background on what is p=
ossible, you might want to read up on PostgreSQL logical replication slots.=
 Essentially, one can write a plug-in which has access to a serialized stre=
am of all updates being applied. There are examples which exist. So one cou=
ld write such a thing that pushes to MSSQL, or one could use such a thing w=
hich publishes change stream as JSON, and develop something to push this to=
 MSSQL. Not suggesting that *you* have to this--just that it's likely tools=
 are based on this, and it would be good for your understanding.