3

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 ?

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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