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@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of J B
> Sent: Monday, October 03, 2005 10:56 AM
> To: pgsql-general@postgresql.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