DSQL Home Page

What is it?

DSQL ("Dynamic" SQL) is a scripting language for SQL, aka Perl for JDBC. As most scripting languages, its focus is on simplicity and rapid development. A typical use would be to import/export data (especially if it involves some logic) or synchronise tables with external data or tables.

Overview of features

Connect and send SQL queries to any JDBC-accessible database/source (and ODBC, through a JDBC-ODBC bridge)
XML and regular expressions support
High-level functions for common datawarehousing functionalities: e.g. table comparison, finding new or modified records...
Basic functions and statements that may be lacking in the target database: e.g. control flow and procedures (not present in MySQL), set difference (not present in MS SQL), etc.
Fixes the features not supported by some JDBC drivers/databases: e.g. scrollable cursors, reading columns in any order, etc.

Installation and Execution

Download here. Java (JRE>=1.2) is required. On Windows, just open dsql.exe; on other systems, launch dsql -i. (more details)

Documentation

See some examples for a quick look at the language. A reference guide is also available.

JDBC Drivers.	Data types.	Variables.
XML support.	Java support.	API.
Regular expressions.