Re: Removing System Objects

Article View: borland.public.interbase.replication

Article #23

Back to borland.public.interbase.replication Previous Next

#23

From: Steve Ball
Date: Sun, 16 May 2004 11:27

25 lines
1784 bytes

Easiest way is attach to the database from the other server via ReplManager
and choose remove system objects, if you can't do that then you can manually
remove the 3 REPL tables (REPL_LOG etc)
You then need to remove all the triggers that are on each table that you
replicate (typically there are 3 per table to deal with insert, update and
delete) not sure if you need to remove the triggers first as they depend on
the REPL_... tables.

First way is defenately the easiest, but depending on the line you use to
connect to the database (ie local network, wan, modem dial up) this could
take a while.

HTH
Steve


"Steve Weston" <sweston{no spam}@westonmuir.com> wrote in message
news:40a22827$1@newsgroups.borland.com...
> I have restored an IB 7.1 db onto another server. How do I remove the repl
> objects (tables, triggers, etc.)?
>
> -- 
> Steven S. Weston
>
>

Technical Details

Message-ID: <40a7501d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <40a22827$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,925ac6238305ae55
X-Google-Attributes: gidf89d7,public
From: "Steve Ball" <SteveBall@noSpam.uku.co.uk>
Newsgroups: borland.public.interbase.replication
References: <40a22827$1@newsgroups.borland.com>
Subject: Re: Removing System Objects
Date: Sun, 16 May 2004 12:27:25 +0100
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 81.5.146.45
Message-ID: <40a7501d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1084706845 81.5.146.45 (16 May 2004 04:27:25 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message