SQL Client

Run as a Java Web Start application
1 GB max memory (use this if you have a 32-bit JVM)
2 GB max memory (for a 64-bit JVM only)
4 GB max memory (for a 64-bit JVM only)

If you have never used this program before, read below first.

Security Warning

You may be prompted about a "Security Warning" (because I am using a self-signed certificate). To resolve this restriction you will need to go to the Control Panel in Windows (or System Preferences on Mac), open the settings for Java, go to the Security tab, and add this website (http://www.mindtrace.net) to the Exception Site List. (On a Mac, you may still have to modify other settings to get this application to run.)

Features include

Provides a graphical environment to run queries, updates/inserts/deletes, browse table meta data, and perform other functions as listed below
Supports DB2, Oracle, MS SQL Server, MySQL, PostgreSQL
Able to compare the schema (table definitions) of two different databases, even databases of different types (e.g. DB2 + MySQL)
Able to export the result of any query to a spreadsheet, tab-delimited file, or as SQL in the form of insert statements. Can also generate insert statements for a different target database than the one queried (e.g. generate insert statements for MySQL from DB2).
Able to generate insert statements for a database as a form of database backup. Furthermore allows you to generate insert statements for MySQL from a DB2 database, etc. (Some limitations apply since for example Oracle has sequences and MySQL has identity columns.)
Able to generate other scripts such as delete/drop all tables in the proper order (based on foreign key relationships).

Known Bugs

If you query DB2 UDB "select * from syscat.columns" you will get a java.io.CharConversionException. Workaround: Avoid selecting the columns high2key and low2key from this table (don't use select *).
(Let me know if you find other bugs!)

Features not fully tested

Export (of a query/table) - columns of type Array, and other less common types may not be exported properly.

One thing that may annoy you

If you have several queries on the SQL tab and highlight one with your mouse to run it, as soon as you hit the Execute button the query will lose the highlight. So if you want to run it again you need to re-highlight it (unless it's the only query there). I hope to address this issue but it's actually not an easy thing in Java due to the way Swing works.