From: Wetmore, Matthew (CTR) <Matthew.Wetmore@express-scripts.com>
To: Scott Ribe <scott_ribe@elevated-dev.com>
To: Erik Serrano <eserranos@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Is a PS - MSSQL Logical Replication Possible??
Date: Tue, 25 Jul 2023 18:54:14 +0000
Message-ID: <d5ea09e054ef41359113f81d33d72cf4@express-scripts.com> (raw)
In-Reply-To: <FFC2DF15-8C94-428C-BB92-DA75350559FB@elevated-dev.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>
Correct, and with dblink on logical slots. The gotcha is making the logical slots persistent in your network config.
I have done db link from one table to another on my primary and then use that 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>
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:
>
> What you indicate is interesting, I am going to find out about the debezium and attunity programs.
> Thank you very much for answering
I don't know how those two are implemented--but for background on what is possible, you might want to read up on PostgreSQL logical replication slots. Essentially, one can write a plug-in which has access to a serialized stream of all updates being applied. There are examples which exist. So one could write such a thing that pushes to MSSQL, or one could use such a thing which 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Matthew.Wetmore@express-scripts.com, scott_ribe@elevated-dev.com, eserranos@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Is a PS - MSSQL Logical Replication Possible??
In-Reply-To: <d5ea09e054ef41359113f81d33d72cf4@express-scripts.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox