dbForge Studio for Oracle v4.0 release notes

Last modified: March 18, 2025

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