dbForge Studio for Oracle v4.0 release notes

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 SQL Query 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