Importing Data From Postgres Table into SQL Server view

Is there a way to read data from PostgreSQL into a SQL Server View ?

I need to access some data in PostgreSQL from my ASP.NET app so I try to read from SQL Server view that already get data from PostgreSQL table.

Thanks in advance.

Answers


It is pretty simple. Step one, download an odbc driver here, according to your system:

http://www.postgresql.org/ftp/odbc/versions/msi/

I found problems installing 09_03_0100 on a clean machine. I suggest 09_02_0100-x64.

Step 2, create an ODBC in System DNS, and test it:

Step 3, create a linked server:

Step 4, query your linked server like this:

SELECT * FROM OpenQuery(PGEXAMPLE, 'select * from yourtable');

Need Your Help

User Model Patch works only for a few requests

ruby-on-rails metaprogramming ruby-on-rails-plugins redmine redmine-plugins

I needed the patch for my Redmine plugin in order to add a new 'has_many' relation for User Model. It works for a while after I start the rails server in dev mode however strange enough stops working

How to install rails 3.2.2 with Ruby 1.9.3, passenger, nginx and rvm?

ruby-on-rails nginx passenger

I followed this tutorial to successfully install Rails 3.0.11 with ruby 1.9.3, passenger, nginx and rvm. But when I tried to configure rails 3.2.2 in similar fashion, I got lots of errors. The main...