Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a Postgresql database that need to read data from two SQL Servers (one SQL Server 2000 and one SQL Server 2008).

I want to setup two dblinks to the SQL Servers.

After googling, foruming, reading documentation, I struggle to find something production ready.

What tool can I use ?

share|improve this question
    
Have you seen this article? postgresonline.com/journal/archives/… –  dezso Oct 12 '12 at 14:38
    
Check out DBI-Link. –  Craig Ringer Oct 13 '12 at 4:18

1 Answer 1

First off, you should be aware that PostgreSQL 8.3 will soon be going EOL. You should probably use a more current version.

In fact, if you did use a more current version (9.1 or later), you could use Foreign Data Wrappers (FDW). Someone has even posted source code for a TDS FDW, which should work for older SQL Server.

If you're somehow stuck with PostgreSQL 8.3, user DBI-Link as Craig Suggests.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.