Extract Firebird Metadata via Delphi

2

First I researched a lot about it and found almost nothing, only the direct extraction by IBExpert which is not what I need.

I would like to know if there is a way to extract Metadata from my entire Firebird database to update another Firebird database that does not have all the tables, triggers ... But via delphi?

    
asked by anonymous 19.11.2018 / 14:41

2 answers

1

You can use the IBExtract component of the IBExpress palette

IBExtract1.ExtractObject(eoDatabase,'',[etDomain,etTable,etRole,etTrigger,etForeign,etIndex,etCheck]); 
TextoMetadata:= IBExtract1.Items.Text;

Since you can only choose the objects you want to extract, in the last parameter

    
21.11.2018 / 14:44
0

You can use isql like this:

isql -extract -o metadata.sql banco.fdb
    
19.11.2018 / 17:50