SQLRunner

alex (at) theparticle.com

What's SQLRunner?

SQLRunner is a simple command-line utility to run SQL queries.

No fancy features. Script-friendly configuration and execution. Standard input/output piping, etc.

Grab binary here: [SQLRunner-20220316.zip].

Grab source at github: https://github.com/profphreak/sqlrunner.git.
E.g. git clone https://github.com/profphreak/sqlrunner.git

You can also grab a bag of popular JDBC drivers: [jdbc_drivers-20120214.zip]. Most of these are outdated, and you should grab the recent ones from database provider's website.

What is it good for?

You can use SQLRunner to:

• use variables in SQL.
• dump data from a database.
• dump DDL from a database.
• retarget DDL from one database to another databse.
• load data from pipes or flat files (current support for oracle, postgres, netezza, greenplum).
• compare data/ddl between databases.
• use analytical/windowing functions with Hadoop Hive (run help on stream.pl)
• distribute a command line program across multliple processors (look through pdist.pl)
• ...and run SQL.