In fact, you need to read all the dependencies from all the SP to know wich one call another one ...
To drop all SP you need first to drop the calling procedures.
To create all SP you need first to create the called procedures.
All those infos are into de DB$ system table.
I've made a module calculating order to drop and create script in correct creation order.
That's all
Georges

----- Original Message -----
From: Tomislav Avramovic
To: ib-support@yahoogroups.com
Sent: Monday, January 27, 2003 1:48 AM
Subject: Re: [ib-support] Re: Metadata SP order extraction problem


Yes the order is the same, but Result script first create all procedures and
triggers without body
and after that alter them with body.
I always use this tool to sinhronize development and production databases
without problems.
This is the link.
http://www.ibase.ru/download/ibcmpexe.zip

> I don't think so. The problem is that when you extract the metadata,
> they are extracted in a "wrong" order, an order wrong for rebuild.
> So if I will use Database Comparer with the (wrong) master as source
> and empty as destination, the result should be the exact copy of
> (wrong) master.
> But if you tell me that Database Comparer does a "dependency" check
> before building the diff metadata, I'm wrong.
> Could you please give me a link to that tool?
> thanks a lot
> Marco Menardi
>
>
> --- In ib-support@yahoogroups.com, "Tomislav Avramovic" <tom@h...> wrote:
> > Hi,
> > > Hi, it works but does not solve the problem (nor without "DESCENDING"
> > > order).
> > > So things seems to be more complicate :( The only simple solution is
> > > the one suggested by Lele Gaifax, AFAIK.
> > > thanks a lot anyway
> > > Marco Menardi
> >
> > Please try excellent Free tool GDB Database Comparer by Boris Loboda
> > This tool compare two extracted scripts from two databases and
> create Result
> > script to sinhronize target database.
> > If you put your script for Master and empty script for Target then your
> > Result script will be Master script in correct order ;-)
> >
> > Tomislav Avramovic
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>


---
Outgoing mail is certified Virus Free .
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21.01.2003


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]