Replicating with SQLMonitor

Article View: borland.public.interbase.replication

Article #173

Back to borland.public.interbase.replication Previous Next

#173

From: Jonathan Neve
Date: Wed, 27 Aug 2003 05:41

21 lines
1766 bytes

Hi!

I just had an idea, I'm posting it here to see if anyone has any ideas 
of why it wouldn't work or of problems I would run into. I would be 
grateful for all feedback.

It ought to be possible (and fairly simple) to replicate using an 
SQLMonitor. I know that in a way it's not as good (changes made manually 
in the database using IBConsole for example will not get replicated), 
but as far as I'm concerned, it would be just as good. All I would have 
to do would be parse the output of the SQLMonitor to turn it into a 
proper SQL statement, and then log it in a table in the database. The 
big advantage of this method is that I can be sure that the server will 
get _exactly_ the same statements as the client, and hence, the results 
also should be the same.

Any ideas?

Thanks!

Jonathan Neve.

Technical Details

Message-ID: <3f4c4486@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,34b4f8c43c880cd4,start
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2003-08-26 22:46:06 PST
Date: Wed, 27 Aug 2003 07:41:23 +0200
From: Jonathan Neve <jonathan@!nospam!microtec.fr>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.replication
Subject: Replicating with SQLMonitor
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 213.11.22.149
Message-ID: <3f4c4486@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1061962886 213.11.22.149 (26 Aug 2003 22:41:26 -0700)
Lines: 22
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail