Re: Is a PS - MSSQL Logical Replication Possible??

Hi there,

Replicating between postgresql instances on different platforms (windows
and linux) but database should be postgres. In other words, you should use
cdc tool like debezium or attunity.

Best Regards,
Ozgur

25 Temmuz 2023 Salı tarihinde Erik Serrano <eserranos(at)gmail(dot)com> yazdı:

> Yes, I believe that it is not possible to carry out this architecture
> without an additional layer or application (which I do not know) exists.
> While it only occurs to me to make an unattended replica (Cron or Daemon
> linux in origin that generates a flat format dump (.sql) on a specific
> share and that windows can pick it up and in turn carry out the load
> through an intermediate job), I don't know... I think it could work...
> although it is not what I would have liked to do.
>
> In any case, your collaboration is appreciated... and who knows, an issue
> will open up to be carried out
>
> greetings friends
>
> Sincerely
>
>
> *Erik R. Serrano Saavedra*
> *Ingeniero de Sistemas Informáticos*
> * Data Base Administrator*
>
> * eserranos(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
> * 998596691*
>
>
> El lun, 24 jul 2023 a las 8:42, Dan Smith (<j(dot)daniel(dot)smith1(at)gmail(dot)com>)
> escribió:
>
>> 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*
>>>
>>