Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] Write from Postgres to SQL Server

[GENERAL] Write from Postgres to SQL Server

From
Guyren Howe
Date:
I find myself in an environment wanting to move to Postgres, having a variety of smaller Postgres databases, but the business currently revolves around a “God” SQL Server database.

I’m looking for general advice about making the two work together.

More specifically, interoperating between the two would be a good deal easier if I have write access from Postgres to SQL Server.

An obvious possibility is to write to SQL Server in a Postgres stored procedure/trigger using code written in Python or whatever, using the facilities native to that language. An obvious issue that arises then is whether I can maintain a persistent connection to SQL Server (assuming that connection setup takes appreciable time).

I am also interested to know if the SQL Server FDW extension works reliably, or any other advice folks may have.

Thanks in advance.

Re: [GENERAL] Write from Postgres to SQL Server

From
John R Pierce
Date:
On 2/13/2017 8:53 PM, Guyren Howe wrote:
> I am also interested to know if the SQL Server FDW extension works
> reliably, or any other advice folks may have.
>

If I was where you were, I'd be testing that FDW, finding any
limitations that might effect your use cases, and working with/around them.




--
john r pierce, recycling bits in santa cruz