Subject | Extracting Metadata through isql-fb -x |
---|---|
Author | Aldo Caruso |
Post date | 2017-10-25T11:48:43Z |
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
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