Article View: borland.public.interbase.replication
Article #659Replication Synchronization questions
From: Mike Senkovich
Date: Mon, 05 Nov 2001 15:43
Date: Mon, 05 Nov 2001 15:43
24 lines
1908 bytes
1908 bytes
Hello all. Question 1: In an N-way replication scheme via dial-up, we will want to add new users to the system over time, and I am looking for the simplest way to do this. I tried to use Synchronization for this purpose. However, when I ran the synchronization it didn't work because the RI constraints are violated. Is there a way you can define the order in which tables are synchronized? If I update my child tables before the parent tables, I won't need to drop the constraints. Or will I need to remove the constraints before synchronizing? Or is there another alternative? Question 2: As a replacement for synchronization, I'm thinking of just taking a different source database (after replication has been done with the server target), copying the database to a new laptop as a new source DB, create a new config DB for this new laptop, remove and re-creating the system objects for both source and target. Would this work as an alternative or is there something else to watch out for? I'm not sure of the impact on the schema numbers in this solution. Thanks. -Mike
Technical Details
Message-ID:
<3be6b3c5$1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f89d7,5f96f450ceef0054,start X-Google-Attributes: gidf89d7,public X-Google-ArrivalTime: 2001-11-05 07:49:49 PST From: "Mike Senkovich" <mikes@decisionsys.com> Newsgroups: borland.public.interbase.replication Subject: Replication Synchronization questions Date: Mon, 5 Nov 2001 09:43:01 -0600 Lines: 26 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: 12.106.6.25 Message-ID: <3be6b3c5$1_1@dnews> X-Trace: dnews 1004975045 12.106.6.25 (5 Nov 2001 07:44:05 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews