What’s New in dbForge Studio for Oracle, v.4.0

Enterprise Editon

Meet new Enterprise Edition with new tools included:

  • Data Generator
  • Database Documenter

SQL Document

  • CTRL+W shortcut for closing the current tab
  • Opening new tabs next to current one
  • Pressing CTRL+N in an SQL window let the new window to inherit the server and database of the current window
  • Displaying the connection color in the status bar
  • Each document creates its own connection
  • The Close All Unmodified Tabs command added
  • The Format Document (CTRL+K+D) command in the shortcut menu of SQL document
  • Closing code completion connection to Oracle Server when it is not being used
  • Query navigation
  • Improved query text parsing
  • Greatly redesigned query execution history

Data Viewer

  • Display of data type and size

Data Export/Import

  • Support for Google Sheets
  • Support for JSON data
  • Redesigned export/import of XML data
  • Preview of generated update script in the wizard
  • Detection of column types when importing data from Excel format

Schema and Data Comparison

  • Expanded Comparison Reports functionality

Schema Comparison

  • New comparison options:
    • Associate column names having similar name options
    • Ignore case in objects names
    • Ignore spaces in objects names
    • Disable dependency analysis
    • Ignore collations
    • Ignore datatypes in column
    • Ignore Table DML Trigger
    • Ignore INSTEAD OF Triggers
    • Ignore firing order for triggers
    • Ignore check constraints
    • Ignore foreign keys actions ON UPDATE and ON DELETE
    • Ignore indexes
    • Ignore index names
    • Ignore primary keys
    • Ignore uniques
    • Ignore triggers present only in Target
    • Ignore indexes present only in Target
    • Ignore Dependent objects in other schemas
    • Ignore double quotes in PL/SQL blocks
    • Ignore External Table Location Information
    • Ignore Parallel
    • Ignores Supplemental Log
    • Ignores Flashback Archive
    • Ignore materialized view START WITH value
    • Ignore character length semantics
    • Ignore ILM Policies
    • Ignore sequence START WITH value
    • Ignore Sequence MinValue
  • New synchronization options:
    • Use DROP and CREATE instead of ALTER for tables
    • Use DROP and CREATE instead of ALTER for views, procedures, functions, triggers, packages, Java Sources
  • Support for new objects and properties:
    • ROWDEPENDENCIES
    • XMLTYPE with XMLSCHEMA
    • External tables
    • Multiple Indexes on the same set of columns
    • Partial indexes for partitioned tables
    • In-memory column store
    • Advanced index compression with partitioned indexes
    • Attribute clustering
    • ILM policies
    • Indexing JSON data and function-based indexes
    • Temporal validity
    • Constraint name of view supported in read-only subquery restriction
    • Materialized view log: FOR REFRESH clause
    • Automatic list partitioning
    • Column-level collation and case-insensitive database
    • Full-text search (JSON search indexes)
    • Real-time materialized views
    • Collation for clustered columns

Data Comparison

  • New data comparison options:
    • Specifying regular expression for:
      • Include tables or views by mask
      • Exclude tables or views by mask
      • Ignore columns by mask
    • Include compare option to ignore spaces in middle of varchar
    • Always exclude newly added objects
    • Ignore datatype for virtual columns
    • Data Tolerance interval
  • Exclusion and Inclusion of columns from/into comparison
  • New data synchronization options:
    • Check for concurrency updates
    • Synchronize current values of sequences
  • Automatic selection of comparison key for objects without equal unique indexes
  • Pre and post script execution during data synchronization

Other Improvements

  • Digital signature for the installation file
  • Trial product activation
  • Greatly improved visual style of the tool
  • FIPS compliance
  • Support for PowerShell
  • Command line execution file wizard
  • Redesigned Generate Script As
  • Improved support for high DPI and 4k resolution