Thread: 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. Anyone been faced with a similar situation? If so, how'd you resolve it? Thank you! John
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
On 10/3/05, Dann Corbit <DCorbit@connx.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? John
On 10/3/05 7:41 PM, "J B" <jbwellsiv@gmail.com> wrote: > On 10/3/05, Dann Corbit <DCorbit@connx.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