Site Map Contact Us Home
E-mail Newsletter
Subscribe to get informed about
Clever Components news.

Your Name:
Your Email:
Previous Newsletters

Products Articles Downloads Order Support
Customer Portal      

DB Extractor Description

Features | Detailed Description

To extract database structure definitions (metadata) Database Comparer VCL uses set of classes called metadata extractors. There are two different metadata extractors, one to extract metadata from SQL scripts (TxxxScriptExtract classes) and another to extract metadata using live database connection (TxxxDBExtract classes). Each database has own TxxxScriptExtract and TxxxDBExtract classes which knows how to work with this specific database. For example for MS SQL there is a TMSSQLScriptExtract and TMSSQLDBExtract clasess, TIBSctiptExtract and TIBDBExtract for Interbase and so on. See Script Extractor

Metadata extractor saves all information about underlying database structure in to a special storage class DB Structure. This class is unified for all types of databases. Such approach makes possible to compare and synchronize databases structure of different types of databases. For example you can compare and synchronize Oracle and MS SQL databases, MS SQL and dBases databases and so on.

Please see the Demos code (DBComparerDemoFib, DBComparerDemoIbo, DBComparerDemoIbx, DBComparerDemoMSSQL, ScriptComparer) and also the indexed Help documentation provided with the Database Comparer VCL installation for more details about using this component.

Property List

   Name    Description
 ExtractObjects Specifies database objects to be extracted from the database.
 DBCConnection Represents database connection.
 DBStructure Provides Database Structure to store extracted database objects.
 ShowFullLog Generate detailed log when extracting metadata.

Method List

   Name    Description
 ExtractDatabase Extracts the database structure.

Event List

   Name    Description
 OnErrorMessage Occurs when an error is generated during extracting, comparing, or updating the database.
 OnLogNextLine Occurs when a new line has been generated and needs to be saved to log.
 OnProgressUpdate Occurs when the progress has changed.

    Copyright © 2000-2021