SQL Executor

The SQL Executor is a component from the Database Comparer VCL library.
This component executes an SQL script and updates the database structure. You can use SQL Executor for running any SQL script on wide range of SQL databases.

Features:

• MSSQL, Oracle, MySQL, InterBase, Sybase, Postgre SQL support
• Execute any SQL statements - Alter, Create, Drop, Insert, Update, Delete and more
• Transactions support - Start, Commit, Rollback
• Run Update in Batch mode
• Load Script from file, Add Statements manually
• Detailed log of executed statements

Execute SQL script in just few lines of code

Use the SQL Executor component together with Database Comparer and Table Data Comparer components for updating and synchronizing database schemas and table data.

Also you are free to use this component independently for running SQL scripts in your application.

SQLExec1.DBCConnection = DbConnection1; SQLExec1.LoadFromFile('c:\scripts\ddl.sql'); SQLExec1.ExecuteScript;

SQLExec.Add(' alter table sales add Name:', stTable, 'sales', dboTable, odbAlter); SQLExec.Add('create trigger sales_insert' :', stTrigger, 'sales_insert', dboTrigger, odbCreate); SQLExec1.ExecuteScript;

Samples in Delphi and C++Builder

Please see the Demos code 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