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

What you indicate is interesting, I am going to find out about the debezium
and attunity programs.
Thank you very much for answering

Greetings

*Erik R. Serrano Saavedra*
*Ingeniero de Sistemas Informáticos*
* Data Base Administrator*

* eserranos(at)gmail(dot)com <eserranos(at)gmail(dot)com>*
* 998596691*

El mar, 25 jul 2023 a las 3:32, Ozgur Kulu (<kuluozgur(at)gmail(dot)com>) escribió:

> 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*
>>>>
>>>