postgresql with SQL Server

Question

I have two databases servers one on SQL Server 2000, second on PostgreSQL on different server. I want to link them. I create duplicate table on the PostgreSQL. Now I want, when new value appeared in SQL Server duplicate them to PostgreSQL. How to do that? How can I see the SQL Server on PostgreSQL? Or must I create an application which will send message from SQL Server to PostgreSQL?

OK, updated your post accordingly.

marc_s
– marc_s

2011-01-26 08:36:46 +00:00
Commented Jan 26, 2011 at 8:36 — marc_s
– marc_s, Commented Jan 26, 2011 at 8:36

Nordic Mainframe · Accepted Answer · 2011-01-26 08:44:19Z

1

Here's a description on how to set up master/slave replication between SQL Server and Postgres (i.e. SQL Server=master updates to Postgres):

http://blog.hagander.net/archives/103-Replicating-from-MS-SQL-Server-to-PostgreSQL.html

Looks like your scenario.

answered Jan 26, 2011 at 8:44

Nordic Mainframe

28.9k10 gold badges69 silver badges83 bronze badges

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

Collectives™ on Stack Overflow

postgresql with SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related