Subject: Re: Trigger updates MS SQL table
From: Robert Treat <xzilla@users.sourceforge.net>
To: "Home (E-mail)" <don@sceifers.com>
Cc: pgsql-interfaces@postgresql.org
In-Reply-To: <001001c377d1$d7db2780$f403a8c0@harvestswiftads.com>
References: <001001c377d1$d7db2780$f403a8c0@harvestswiftads.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Date: 15 Sep 2003 15:56:58 -0400
Message-Id: <1063655818.20709.65.camel@camel>
Mime-Version: 1.0

IIRC some folks on -hackers are working on cross database queries to
interface with oracle databases, theres a chance that could work for sql
server too. Someone else on -hackers was looking at an internal soap/xml
communications method to do similar things to what your describing. You
might want to check the archives on both ideas. 

The other option, and probably more doable, is to write a function in
one of the untrusted languages to communicate with your xml service via
sockets.

Robert Treat

On Wed, 2003-09-10 at 15:29, Home (E-mail) wrote:
> Is it too presumptious that there should be a direction I can go to solve my
> problem.
> 
> Right now, I have a postgres environment that our business is run on and SQL
> Server 2000 databases that our customer ASP solutions run in. Both serve
> their purposes well. So, I need both. What I was hoping, was to get a form
> of replication going between the two. In a perfect world, my trigger would
> just create an ODBC connection to the MS Sql server and run the
> update/insert query. I know that cannot exactly happen, it just doesn't work
> that way.
> 
> But can I create a trigger that allows me to connect to a SOAP/XML service
> and deliver the update via a stored procedure call? Is this too much to hope
> for, or are people doing this already?
> 
> Thanks
> Don Sceifers
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL