Subject Re: [ib-support] Re: Metadata SP order extraction problem
Author Tomislav Avramovic
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