Date: June 2007

Oracle SQL Developer is a free graphical tool for database development. The initial release, in March 2006, provided users with a graphical interface to interact with database objects by providing the ability to browse the database, run SQL, PL/SQL and SQL*Plus statements, execute SQL scripts, and edit and debug PL/SQL statements. This initial release also provide a suite of reports to further interrogate the dictionary. SQL Developer 1.0 was quickly followed by 2 patch releases and the SQL Developer 1.1 in December 2006.

Oracle SQL Developer 1.1

The main goal of SQL Developer 1.1 was to bring file-based PL/SQL Editing to the user base, while also broadening the general offering of the tool.

Oracle SQL Developer 1.2

Oracle SQL Developer 1.2 is known as the "Migration Release". This latest release of SQL Developer includes the Developer Migration Workbench, a new, redeveloped tool that greatly extends the functionality and usability offered by the original Oracle Migration Workbench. Its tight integration with SQL Developer provides users with a single point to browse database objects and data in third party databases, and to migrate from these databases to Oracle.

Additionally SQL Developer 1.2 includes support for Oracle Application Express 3.0.1(Oracle APEX).

• Oracle SQL Developer Migration Workbench
  • Full integration with SQL Developer means that users have one tool to browse third party databases, migrate selected objects to Oracle and then work with them.
  • Quick Migration Wizard offers least privilege migration i.e No DBA privilege is required.
  • Step driven migration offers control at each stage of the migration process.
  • Fine grain migration support provides users with the ability to select specific objects for migration.
  • Complex object migration supports stored procedures, triggers and views.
  • Translation Scratch Editor offers single statement migration.
  • Translation Difference Viewer provides side by side comparison by matching statements and blocks.


• Oracle APEX 3.0.1 (Oracle APEX 3.0.1 is scheduled for release in 2007)
  • Connect to and browse all Oracle APEX applications associated with a database schema (At application and page level)
  • Run a number of reports that allow users to report on Workspaces, Applications, Pages and Schemas
  • Export and Import Oracle APEX applications using a context menu
  • Read more...

Download Oracle SQL Developer 1.2, released in June 2007, from OTN.

To find out more about the new Migration Workbench, see this dedicated site on OTN.