Sql task

This task is used as nested element of the <export> task to execute arbitrary SQLs before export.

Each sql tag must contain a single SQL which SQL should be added between the enclosing <sql> tags.

Java class is org.chur.ant.db.jdbsynch.export.SqlTask

Example

<taskdef name="export" classname="org.chur.ant.db.jdbsynch.export.ExportTask"/>
<export
driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@tiger:1521:tigerdb"
userid="sys"
password="change_on_install"
dest="export1.xml"
profile="mysql">
<sql>ALTER SESSION SET CURRENT_SCHEMA=SCOTT</sql>
<table tableName="CUSTOMERS"/>
</export>