Postgres Pro
Downloads
Home   >   mailing lists

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

From Dan Smith
Subject Re: Is a PS - MSSQL Logical Replication Possible??
Date
Msg-id CAK50Jrz0j8tE3u06O3ACFJBL+0SQDY0Yf+tOd0ESKRuE4GUtPw@mail.gmail.com
Whole thread Raw
In response to Is a PS - MSSQL Logical Replication Possible??  (Erik Serrano <eserranos@gmail.com>)
Responses Re: Is a PS - MSSQL Logical Replication Possible??
List pgsql-admin
Tree view
I think what you are looking for is a Change Data Capture (CDC) solution.  This is going to require a system in the middle that can speak to both database systems.  Note these implementations can be brittle (replication can fail) and take some tinkering to get working well.

I recommend you look in to tools such as Debezium (https://debezium.io), AWS Data Migration Service (DMS), or maybe some data lake implementation and scripts could be used (apache hudi, data bricks delta lake, or other).


Best regards,

Dan Smith

On Sun, Jul 23, 2023, 22:30 Erik Serrano <eserranos@gmail.com> wrote:

Dear Masters,

Is it possible to make a logical replica between a postgresql 12 and a sql server 2019?
Technically I want to make a multimaster logical replica to a subscriber and this in turn replicates to a MSSQL 2019 AlwaysOn server...
Is it possible to make this type of structure or impossible?
Please tell me...

Regards and thank you very much

Atte.




image.png


Erik R. Serrano Saavedra
Ingeniero de Sistemas Informáticos
      Data Base Administrator
        eserranos@gmail.com
                 998596691
Attachment

pgsql-admin by date:

Previous
From: Jef Mortelle
Date:
Subject: Re: Upgrade from PG12 to PG
Next
From: Scott Ribe
Date:
Subject: Re: Upgrade from PG12 to PG