From: | Dan Smith <j(dot)daniel(dot)smith1(at)gmail(dot)com> |
---|---|
To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Is a PS - MSSQL Logical Replication Possible?? |
Date: | 2023-07-24 12:42:23 |
Message-ID: | CAK50Jrz0j8tE3u06O3ACFJBL+0SQDY0Yf+tOd0ESKRuE4GUtPw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)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: image.png]
>
>
> *Erik R. Serrano Saavedra*
> *Ingeniero de Sistemas Informáticos*
> * Data Base Administrator*
>
> * eserranos(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
> * 998596691*
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2023-07-24 12:52:26 | Re: Upgrade from PG12 to PG |
Previous Message | Jef Mortelle | 2023-07-24 06:38:36 | Re: Upgrade from PG12 to PG |