Free Database Tools

Have you ever needed to create a registered table or (gasp!) look at one of Documentum’s system tables, but didn’t have access to the database vendor’s client application or tools? Not everyone has Oracle’s Database Designer, SQLPlus, SQL Server Studio, or Query Analyzer on their desktop. That’s OK, because now there are several free alternatives:

Oracle:

SQL Server:

DB2:

Generic:

Probably the best of all worlds is a single tool that can interface with all of these (and more) databases.  SQuirreL SQL provides SQuirreL Universal SQL Client which does just that:  http://www.squirrelsql.org/.  SQuirreL uses the JTDS  JDBC driver for SQL Server and Sybase connections.  You can find it here: http://jtds.sourceforge.net.  Copy the file jtds-1.2.2-dist\x86\SSO\ntlmauth.dll from the unzipped JTDS to \jdk\jre\bin and restart SQuirreL.

UPDATE: As suggested by Pawan in a comment, the SQLExplorer plugin for Eclipse is also a nice free database tool.  The exceptionally nice feature of the SQLExplorer plugin is that you don’t have to leave your development IDE to use it.  Here is the SourceForge page for the project:  http://eclipsesql.sourceforge.net.  Note, there is a standalone version also!

Advertisements

About Scott
I have been implementing Documentum solutions since 1997. In 2005, I published a book about developing Documentum solutions for the Documentum Desktop Client (ISBN 0595339689). In 2010, I began this blog as a record of interesting and (hopefully) helpful bits of information related to Documentum, and as a creative outlet.

3 Responses to Free Database Tools

  1. doquent says:

    Scott,

    Thanks for sharing this.

    Another useful free basic DB tool is the Data Source Explorer view in Eclipse. It is listed under Window > Show View > Other > Data Management. It is quite lean and lets me query, load, export, and run SQL. against databases. I am able to connect to any database for which I have a JDBC JAR.

    It doesn’t have advanced fancy features, but it is very convenient to run within Eclipse, and probably covers over 80% of my usual needs. Several DB plugins are also available for Eclipse.

    Thanks,
    Pawan

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: