On Friday 2002-02-22 at 18:33:56 +0100, Duilio Foschi wrote:

> 1. is there a way to retrieve the whole structure of a db (eg all table
> structures, all constraints, all indexes, all SPs, etc) and store it into a
> file ?

You can use the isql command line tool, for example:

/opt/interbase/bin/isql -x -d mydb.gdb -u username -p pass > meta.txt


Windows syntax is the same, I believe, except isql will be in a
different location.

> 2. is there a way to compare the structure file with another database and
> find the differences ?

I've used the diff utility in the past, with reasonable success:

diff [options] from-file to-file

It should be available for Windows (for example, as part of cygwin).
Success depends upon isql outputting objects in a consistent order.
I've only done it a couple of times, but it seems to be consistent.


Hope that helps.

> TYIA

Nessun problema.


David Trudgett