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

Your Name:
Your Email:
 
SUBSCRIBE
 
Previous Newsletters
 






Products Articles Downloads Order Support
Customer Portal      

Script Extractor

Features | Detailed Description

The Script Extractor is a component from the Database Comparer VCL library.
This component parses the SQL/DDL script, extracts all database objects and saves it in to the DB Structure component.

Features:

  • Extract Tables, Triggers, Stored Procs, Indices, Foreign Keys, Views and more
  • Extract specific database objects or entire database
  • MSSQL, Oracle, MySQL, InterBase, Sybase, Postgre SQL support
  • Parse Triggers and Stored Procedures scripts
  • Detailed log of extracted objects
  • Event Notifications for extracting progress and occurred errors

Parse SQL script in just few lines of code

Use the Script Extractor component together with DB Comparer and DB Structure components for comparing two SQL/DDL scripts or database and SQL/DDL script and generating the update script.

IbScriptExtract1.DBStructure := DbStructure1;
IbScriptExtract1.ScriptFileName := 'master_ddl.sql';
IbScriptExtract1.ExtractDatabase;

IbScriptExtract2.DBStructure := DbStructure2;
IbScriptExtract2.ScriptFileName := 'target_ddl.sql';
IbScriptExtract2.ExtractDatabase;

DbComparer1.DBStructureMaster := DbStructure1;
DbComparer1.DBStructureTarget := DbStructure2;

DbComparer1.CompareDatabases;

Samples in Delphi and C++Builder

Please see the Demos code (ScriptComparer) and also the indexed Help documentation provided with the Database Comparer VCL installation to learn more about using this component in your application.

Complete Delphi source code

When Purchasing the Database Comparer VCL you receive the full sources for all components and also free unlimited support.

Interested?

    Copyright © 2000-2024