Search Postgresql Archives

Re: Integration with MS Sql Server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux