Release Notes

• Version 2.3.0
• Version 2.2.0
• Version 2.1.0
• Version 2.0.0

Version 2.3.0

• Data export wizard supporting multiple output formats:
  • SQL - Creates a SQL insert script that can be run against a database.
  • CSV - Creates a CSV (Comma Separated Values) list that can be used in a spreadsheet.
  • XML- Creates a XML document that can be transformed to various other formats.
  • HTML - Creates a HTML document that can be inserted in most office applications.
• Oracle enhancements:
  • Tablespace analyser.
  • Asynchronous execution of explain plan.
  • Session info now shows old and current SQL statement.
• New database connector for H2.
• Driver settings dialog allows to enable/disable driver archives.
• Several minor improvements and bug fixes.

Version 2.2.0

• The connector chooser dialog provides access to an integrated port scanner to search for open ports on database servers.
• In addition to primary and foreign keys on table columns the database navigator also shows unique keys on columns now.
• Search for software updates of SQL Developer implemented (can be initiated by the user from the help menu).
• The database comparison has been extended to compare constraints, indexes, procedures, functions and triggers.
• Oracle 10g recycle bin extension added to examine and manage dropped objects.
• Graphical Oracle database monitor implemented.
• Graphical Microsoft database monitor implemented.
• In addition to the ODBC/JDBC Bridge driver the Microsoft SQL Server connector now also supports connections via the jTDS driver (without ODBC).
• Microsoft Access shows forms, reports, pages, modules and macros in the database navigator.
• Bug in Microsoft Access view source retrieval added. Expressions are not quoted any more.
• Diagram editor:
  • PNG image file export function implemented.
  • Context menu (right mouse button) in diagram window.
  • Functions added for aligning objects against each other.
  • Improved browser for database object import.
• HTML added as clipboard format for SQL Editors to support colored text.
• Bookmarks:
  • History size can be configured by the user now.
  • Copy bookmark action in SQL statement editor added.
• Query result in SQL statement editor now also visualizes byte arrays.
• System info in about dialog added.
• Several minor improvements and bug fixes.

Version 2.1.0

• Docking desktop.
• History for SQL statements and bookmarks repository.
• New node in database navigator showing the dependencies of a view.
• Oracle instance parameters are now shown in the database info dialog (visible only with DBA privileges).
• Drag and Drop of text blocks in SQL editors.
• Missing or corrupted driver archives are shown as such in the settings dialog.
• Plugins information in settings dialog.
• Support for look and feel decorations implemented (This decorates title bars and borders of windows).
• Diagram editor:
  • Color choosers now also provide a transparent color.
  • Fixed partial rotated labels.
• Several minor improvements and bug fixes.

Version 2.0.0

• Complete technical redesign.
• Refactored dialog for opening connections:
  • Detailed driver info for each connector plugin.
  • Direct access to class path configuration.
  • Optional user defined name for all connections.
  • Basic connector plugin now allows flexible definition of attributes and retrieves available arguments supported by the driver.
  • Oracle connector plugin now allows to connect as SYSDBA or SYSOPER.
• Unicode support for file I/O.
• Menu with recently opened connections added.
• Tabbed bar added for easy switching between windows.
• Exported keys information for tables in database navigator.
• Basic extension for catalog and schema comparison added.
• Basic extension for dissolving object depencies added.
• New diagram editor with zoom, automatic layout and SVG support.
• Extended quick browse for simple creation of complex joined queries.
• Microsoft SQL Server enhancements:
• Microsoft SQL Server connector added.
• Process viewer extension implemented.
• Server monitor extension implemented.
• Remote command shell extension added.
• MySQL enhancements:
  • Process viewer extension implemented.
• Oracle enhancements:
  • Filter for sessions extension added.
  • Jobs extension added.
  • Oracle Text (interMedia) extension added.
  • Tablespace usage information in database navigator.
  • User roles and privileges in database navigator.
  • Unique key constraint columns in database navigator.
  • Segments information for various objects.
  • Added missing columns clause in alter trigger function.
• New database connector for Ingres.
• New database connector for Firebird.
• New database connector for Mckoi SQL Database.
• New database connector for Mimer SQL.
• New database connector for PostgreSQL.
• The GO command is now recognized as a statement terminator in SQL script editor.
• Echo output option for commands in SQL script editor.
• Added support for multiple result sets in SQL script editor.
• New find and replace text dialog with regular expressions.
• Clob viewer supports text search, XML syntax highlighting and XML formatting.
• Blob image viewer now supports zooming and allows to copy the displayed image to clipboard.
• Several minor improvements and bug fixes.