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 ?

Stephan
  • 1,513
  • 4
  • 18
  • 27

1 Answers1

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.

Josh Berkus
  • 1,216
  • 8
  • 6