Oracle SQL Developer

New Features in Release 3.1

  • DBA Utilities

    Release 3.1 continues to expand on SQL Developer's DBA functionality. RMAN, Oracle Recovery Manager, is now part of the DBA navigator. An easy to use wizard takes you through the scheduling of a full database backup. Backups can be stored to disk, tape or a combination. RMAN scripts are generated to restore or recover a whole database, tablespaces, datafiles and archived logs. Reports are available to manage backup jobs, backup sets, image copies and RMAN settings.

  • Data Pump

    To enable very high speed movement of data and metadata from one database to another, SQL Developer has added the Oracle Data Pump technology. Use SQL Developer's Data Pump UI to import and export your Database, Tablespaces, Schemas, and Tables. Select the option to import and export just the DDL, Data or both. Data Pump also offers scheduling capabilities. Learn more by viewing these demonstrations.

  • Database Diff

    Completely redesigned, DB Diff now provides a more reliable comparison and difference management support of your DDL. Select what to include in your DDL Generation and select from various comparison options such as match constraints by name or by definition. Objects can be further filtered. Scripts are generated to synchronize the source and target destinations.

  • Database Copy

    Database Copy is redesigned to enhance performance and offer more flexibility. Choose from various copy options: copy objects, copy a schema or consolidate multiple schemas into one, copy tablespaces, copy DDL, data or both. Further refine your copy by using the filtering capability.

  • Migrations

    Migrations in 3.1 include enhancements to Teradata and Sybase. Teradata support has expanded to include a SQL Translator, Enterprise Capture and Offline Migration. Sybase now offers TSQL Translation with support for outer join syntax including legacy outer join syntax and triggers.

  • PDF Reports

    The Reports dialog is enhanced for ease of use and flexibility to create or update a report. The PDF feature allows the user to change and save their PDF options for a specific report in the Reports Navigator.  Customize the visual layout and apply security with password protected encryption to your PDF Reports. Learn more by viewing these demonstrations.