ADExecutor

All about AnyDAC SQL Script execution utility.

Group

Links

General

AnyDAC Executor is the major SQL script console execution tool, supporting many SQL scripting dialects. The ADExecutor supports:

standard SQL commands, like INSERT or SELECT;
stored procedure language commands, like CREATE PROCEDURE;
script execution control commands, like SPOOL, SET ECHO, etc., coming from Oracle SQL*Plus, Microsoft ISQL, and other script execution utilities, suplied by DBMS vendors.

AnyDAC itself uses ADExecutor to build demo databases. Users can use ADExecutor as a ready-to-use tool to deploy database objects.

Command Line Parameters

Run Executor utility with -? argument. It outputs the following reference text:

AnyDAC Executor v 3.0.1 (Build 1337)
(c)opyright DA-SOFT Technologies 2004-2013 (http://www.anydac.net)

Use: ADExecutor [-d <name>] [-n <file name>] [-u <user>] [-w <pwd>] [-l] [-e]
             [-i] [-s] [-p <path>] [-t <path>] [{<scripts>}] [-a {<arguments>}]

-d        - connection definition name
-n        - connection definitions file name
-u        - user name
-w        - password
-l        - login prompt
-p        - path to SQL script files
-t        - path to data files
-e        - stop script execution only after a "drop non-existing object" error
-i        - stop script execution after first error
-s        - do not show messages during SQL script execution (silent)
-a        - a list of script arguments
-? or -h  - show help

Notes:
1. If scripts are not specified, ADExecutor will read standard input.

Examples:
1. ADExecutor -d Oracle_Demo -i -p x:\MyScripts s1.sql s2.sql
Executes the s1.sql and s2.sql scripts from directory x:\MyScripts, using
the Oracle_Demo connection definition, does not stop on errors.
2. echo drop table mytab | ADExecutor -d MySQL_Demo
Executes the command captured from standard input.