Re: Integration with MS Sql Server

On 10/3/05 7:41 PM, "J B" <jbwellsiv(at)gmail(dot)com> wrote:

> On 10/3/05, Dann Corbit <DCorbit(at)connx(dot)com> wrote:
>> Using SQL*Server, and OLEDB or ODBC data source can be connected as a
>> linked server. Then, TSQL queries can go against PostgreSQL tables as
>> though they were ordinary SQL*Server tables (but they have 4 part names
>> instead of 3 part names).
>
> Unfortunately, mirroring PostgreSQL within MS SQL Server is not an
> option in our case...we need to do it the other way around.
> Interesting info nonetheless...thanks.
>
> Is there no other way?

I'm sorry, but I missed the original post, but have you looked at DBI-Link?

http://www.pgfoundry.org/projects/dbi-link
http://www.pervasivepostgres.com/postgresql/tidbits_June05.asp

Sean