Script Extractor

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 Database 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 Database Comparer and Database 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?

• Check Detailed Description
• Download Trial version
• Purchase License
• Have questions? Contact us