Article View: borland.public.interbase.replication
Article #641Re: N-Way replication configuration questions
From: Steve Ball
Date: Wed, 24 Oct 2001 10:12
Date: Wed, 24 Oct 2001 10:12
53 lines
2643 bytes
2643 bytes
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:
<3bd69406_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!uunet!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>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:14:13 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> Subject: Re: N-Way replication configuration questions Date: Wed, 24 Oct 2001 11:12:17 +0100 Lines: 55 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: <3bd69406_1@dnews> X-Trace: dnews 1003918342 195.173.39.197 (24 Oct 2001 03:12:22 -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!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews