SQL Server to PostgreSQL

Question

I need to create a trigger in SQL Server.

Trigger works:

If I found new line where T = 'A'; then add this line to PostgreSQL table.

Is it possible to create it, without software?

(I know how to create trigger, but how to create connection between two servers?

Answer 1

You will need to setup postgres as a linked server to SQL server.

See this article to see how to do so.