SQL Client
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.