Re: Is a PS - MSSQL Logical Replication Possible?? - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Is a PS - MSSQL Logical Replication Possible??
Date
Msg-id FFC2DF15-8C94-428C-BB92-DA75350559FB@elevated-dev.com
Whole thread Raw
In response to Re: Is a PS - MSSQL Logical Replication Possible??  (Erik Serrano <eserranos@gmail.com>)
Responses Is a PS - MSSQL Logical Replication Possible??
List pgsql-admin
> 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
PostgreSQLlogical replication slots. Essentially, one can write a plug-in which has access to a serialized stream of
allupdates being applied. There are examples which exist. So one could write such a thing that pushes to MSSQL, or one
coulduse such a thing which publishes change stream as JSON, and develop something to push this to MSSQL. Not
suggestingthat *you* have to this--just that it's likely tools are based on this, and it would be good for your
understanding.


pgsql-admin by date:

Previous
From: Erik Serrano
Date:
Subject: Re: Is a PS - MSSQL Logical Replication Possible??
Next
From: Erik Serrano
Date:
Subject: Re: postgis Error during upgrade