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

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