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.
It is pretty simple. Step one, download an odbc driver here, according to your system:
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');