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