SQL Server for PostgreSQL

Question

I need to create a trigger in SQL Server.

The trigger works:

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

Can I create it without software?

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

+2

Dezigo May 14 '10 at 7:21

1 answer

Oded · Accepted Answer · 2010-05-14T07:37:26+0000

You will need to configure postgres as a linked server with a SQL server.

See this article to see how.