CODEWITHSUNDEEP
postgresqlsql-server-2008sql-server-2005
Pavan Kumar
Pavan Kumar

Reputation: 463

Connecting a SQL server from a postgresql instance

I have an SQL server running with lot of existing Data and I need to connect it via postgresql instance which is on my system. I used the below link. But its not actually what I want.

http://blog.slalom.com/2011/03/14/connecting-to-a-postgresql-instance-using-sql-server-integration-services/

Can anyone suggest a clear way to attain this.?

Upvotes: 1

Views: 17533

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324681

SQL/MED (implemented in PostgreSQL core as "foreign data wrappers") is supposed to solve this problem, but the current implementation in PostgreSQL is rather limited. See http://wiki.postgresql.org/wiki/Foreign_data_wrappers . The ODBC FDW may be sufficient for your needs, give it a go and see.

Alternately, you can use DBI-Link, which uses Perl DBI drivers (including but not limited to the Perl DBI ODBC bridge) to talk to other databases. You'll find dbi-link on PgFoundry.

Upvotes: 4

Related Questions