🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #642

Re: N-Way replication configuration questions

#642
From: Steve Ball
Date: Wed, 24 Oct 2001 10:14
63 lines
2928 bytes
Sorry I forgot to say thats all in the scheme database that you created.
Steve

"Steve Ball" <Steve@ClubRunner.co.uk> wrote in message
news:3bd69406_1@dnews...
> I'll second that feature request. :o)
> To be fair I think its something Vince said he will be adding at some
> time. -
>
> Currently I write a script to do it, using the other fields in the
> REPLATIONS tables to get there "where" criteria.- (I always check I have
the
> correct numbers by making one row level condition "poo" to start, I then
> find "poo" in the conditions and I have the REPLNO and DBNO
>
> So if you had DBNO 7 and REPLNO 11 use something like :
>
> update relations set CONDITION = 'add condition here'
> where
> DBNO = 7 and
> REPLNO = 11
>
> To remove the conditions from a table you need to leave a space in the
field
>
> update relations set CONDITION = ' '
> where
> DBNO = 7 and
> REPLNO = 11
>
>
>
> "Mike Senkovich" <mikes@decisionsys.com> wrote in message
> news:3bd5e6bd$1_1@dnews...
> > > They cannot be copies of each other, since the SCHEMA NO must be
> > > different for each one...
> >
> > Ok.  I'm assuming this means I will need to create a configuration
> database
> > from scratch for each laptop.  The DB structure of Source and Target DBs
> are
> > identical, so let me know if there is a workaround to having to create
> them
> > each from scratch.  I expect to create at least 10 configuration DBs.
> >
> > We will be using the row level replication condition for 60 of the
tables
> in
> > the database.  The DB structure of the source and target DBs are
> identical.
> > Is there any way to implement this identical replication condition for
> each
> > of the 60 tables without selecting each table, clicking "settings" and
> > pasting the condition?
> >
> > If not, can I submit a feature request for this?  :-)
> >
> > Thanks.
> > -Mike
> >
> >
>
>
Technical Details
Message-ID: <3bd6946e_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews
References: <3bcf4603$1_1@dnews> <3BD0399A.677C6367@replication.co.za> <3BD03AA6.3B84AEF@replication.co.za> <3bd5e6bd$1_1@dnews> <3bd69406_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,fc74097c2751825d
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2001-10-24 03:36:17 PST
From: "Steve Ball" <Steve@ClubRunner.co.uk>
Newsgroups: borland.public.interbase.replication
References: <3bcf4603$1_1@dnews> <3BD0399A.677C6367@replication.co.za> <3BD03AA6.3B84AEF@replication.co.za> <3bd5e6bd$1_1@dnews> <3bd69406_1@dnews>
Subject: Re: N-Way replication configuration questions
Date: Wed, 24 Oct 2001 11:14:01 +0100
Lines: 65
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 195.173.39.197
Message-ID: <3bd6946e_1@dnews>
X-Trace: dnews 1003918446 195.173.39.197 (24 Oct 2001 03:14:06 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews