Hello Normally I use isql-fb with -x switch to extract metadata in order to compare the database development structure with the database production structure and figure out the changes I must apply to the latter.
Both outputs are redirected to files, and I use diff command to compare them. The only problem I find is that, while creation DDL sentences for Domanins, Tables, Procedures, Triggers, Privileges, Triggers, etc. are alphabetically sorted, creation DDL for Views aren't. The isql-fb command applied to two databases which have the same declared Views, outputs their creation DDL sentences in different order, which makes analysis through diff command difficult. I will appreciate any help. Thanks, Aldo Caruso
