From: Robert Treat <xzilla@users.sourceforge.net>
To: Home (E-mail) <don@sceifers.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Trigger updates MS SQL table
Date: 15 Sep 2003 15:56:58 -0400
Message-ID: <1063655818.20709.65.camel@camel> (raw)
In-Reply-To: <001001c377d1$d7db2780$f403a8c0@harvestswiftads.com>
References: <001001c377d1$d7db2780$f403a8c0@harvestswiftads.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: xzilla@users.sourceforge.net, don@sceifers.com
Subject: Re: Trigger updates MS SQL table
In-Reply-To: <1063655818.20709.65.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox