Article View: borland.public.interbase.replication
Article #642Re: N-Way replication configuration questions
From: Steve Ball
Date: Wed, 24 Oct 2001 10:14
Date: Wed, 24 Oct 2001 10:14
63 lines
2928 bytes
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!dnewsReferences:
<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