I just make a copy of the database when not in use
and then delete all info and backup the empty database.

I have been assisting Jason in adding some of the
missing features, but FB develops too many new
ones too fast :)

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, February 25, 2006 10:29 PM
Subject: Re: [firebird-support] isql metadata extraction problems


> At 03:46 PM 26/02/2009, Hans wrote:
>
>>IB_SQL's metadata extract tool makes a lot of mistakes and hardly supports
>>the new FB 2.x features.
>
> I use a version compiled with the latest IBO version and it correctly
> extracts the DDL in my databases. (I know you have the means to do this
> for yourself, too). Do you have a list of "new FB 2.x features" that it
> extracts incorrectly? It shouldn't be too big a deal for you to list them
> out and report them to the IBO list.
>
>>Always have to manually re-sequence the extracted
>>metadata to be able to contruct a new database from it
>
> Yes: you always have to do that, with any metadata extraction tool I've
> used, including isql. That's down to the way that Firebird stores and
> refers to dependencies, AFAIU. I've always recommended that you should
> strictly maintain a complete and accurate set of scripts for each
> database, from Day One of development. It's a minimum fulfilment of ones
> responsibility as the db admin. It's not wise to rely on an extraction
> tool to cover exposed nether parts. ;-)
>
>>and then manually add any used new FB 2.x features.
>
> As above - rather than such unspecific wibbles in the wrong place, it
> would make sense to report the specific problems you've had, in the
> specified place.
>
> ./heLen
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>