DB sync ?

Article View: borland.public.interbase.opensource

Article #5566

Back to borland.public.interbase.opensource Previous Next

#5566

From: Paul
Date: Mon, 26 Mar 2001 16:10

13 lines
1246 bytes

Hi everybody.
I have a question, and I hope the answer won't be "not possible", but I'm
afraid it will be.

I've a big database on a main server.
I want to synchronize 4 rows of 1 table on another server (it's for perf
optimization). I imagine doing this using a trigger. But can a trigger
update or insert a record on another db ? I've found no doc about this.

The other solution would be to create a C UDF, which does the job. But it's
quite dirty (maintaining problem).
--
Paul

Technical Details

Message-ID: <3abf6afc$1_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews!213.56.228.92

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 106772,7947e9f7a536047b,start
X-Google-Attributes: gid106772,public
X-Google-ArrivalTime: 2001-03-26 10:32:22 PST
From: "Paul" <paul@floritel.com>
Newsgroups: borland.public.interbase.opensource
Subject: DB sync ?
Date: Mon, 26 Mar 2001 18:10:14 +0200
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: 213.56.228.92
Message-ID: <3abf6afc$1_2@dnews>
X-Trace: 26 Mar 2001 08:14:52 -0800, 213.56.228.92
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!news.maxwell.syr.edu!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews!213.56.228.92