Sunday, May 15, 2011

Running Oracle SQL Developer 3.0 on Ubuntu

This free graphical tool from Oracle looks very powerful for database development and seems to be equivalent to Microsoft SQL Server Management Studio. Its feature list is quite impressive. This version (v3.0.04.34, March 2011) incorporates Data Modeler and Query Builder support. It can also make a read-only connection to non-Oracle databases (MySQL, SQL Server, MS Access, Sybase, DB2 UDB and Teradata).

  • Download "SQL Developer for other platforms" from Oracle and unzip it.
  • Create a new directory called ".sqldeveloper" in the home directory.
  • Create a new text file called "jdk" in ".sqldeveloper" and add a JDK (Java Development Kit) installation path to the file; for example,
/usr/lib/jvm/java-6-sun
  • Allow the uncompressed "sqldeveloper.sh" to be executed as program.
  • Run "sqldeveloper.sh".

No comments:

Post a Comment