Re: Integration with MS Sql Server

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).

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of J B
> Sent: Monday, October 03, 2005 10:56 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Integration with MS Sql Server
>
> Guys,
>
> We have an in-house application that absolutely has to run against MS
> Sql Server. We also have an application that doesn't, but that needs
> to integrate with that MSSQL database.
>
> I'm considering any options, including using application code as an
> integration point. I'd prefer to somehow mirror the MS SQL db in
> PostgreSQL, but not sure if that's possible.

It is a lot easier to go the other way around (where the PostgreSQL
server is mirrored inside of the SQL*Server via linked server).

> Anyone been faced with a similar situation? If so, how'd you resolve
it?

Here is a commercial solution we wrote:
http://www.connx.com/products/change-data-capture/DataSync.asp

I am sure that there are lots of other alternatives.

> Thank you!
>
> John
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org