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 it here: [SQLRunner-20120214.zip].

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.
• compare data/ddl between databases.
• ...and run SQL.