Extract Metadata from Firebird via Delphi

Asked

Viewed 580 times

2

First I researched a lot on the subject and found practically nothing, only the direct extraction by Ibexpert that is not what I need.

I wonder if there is a way to extract the metadata from my entire Firebird bank to update another Firebird database that does not have all tables, triggers... But via Delphi?

delphi

  • isql -Extract -o Metadata.sql database.fdb

  • works with any version of Firebird?

  • Starting with version 6

  • Reginaldo Rigo worked out. Another thing you know if there is any way to compare two banks Firebird and update what is not with all tables, triggers...?

  • DBCompare http://clevercomponents.com/downloads/dbcomparer/dbcdownload.asp

  • Thank you very much Reginaldo Rigo

Show 1 more comment

2 answers

1


You can use the component IBExtract palette Ibexpress

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

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

  • I was breaking my head running commands on isql, but now it’s much easier. Thank you Leo.

0

You can use isql this way:

isql -extract -o metadata.sql banco.fdb

Browser other questions tagged delphi

You are not signed in. Login or sign up in order to post.