>>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. ;-)
>

Some third party tools extract metadata statements (for
a complete database) in such a way that you can just run
the script.

I know of a one, at least :-)


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com