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
