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?

Oded · Accepted Answer · 2010-05-14 07:37:26Z

1

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

See this article to see how to do so.

answered May 14, 2010 at 7:37

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1