Softpedia >Windows >Internet >Servers >Database Utils >dbForge Studio for Oracle >  Changelog

dbForge Studio for Oracle Changelog

What's new in dbForge Studio for Oracle 4.5.117

Jul 22, 2023
  • Improvements:
  • Added connectivity support for Oracle 23c
  • User-reported and internal bug fixes:
  • Fixed an error that occurred when retrieving metadata for schema objects in Documenter (D115789)
  • Refined the conditions for activating the AUTO COMMIT mode button in SQL Document (D108656)
  • Resolved an issue with hints in the Completion List that occurred when invoking a hint before a subquery (D116631)
  • Fixed an issue with data export to Excel (D121095)
  • Fixed the loss of TABLESPACE and STORAGE OPTIONS during the synchronization of tables, indexes, and materialized views (D118420)
  • Resolved an issue with unnecessary indentation being added when formatting queries with the USING clause in a JOIN (D123279)
  • The application runs out of memory when backing up databases containing large objects (> 1GB) (D121116)
  • Poor user interface responsiveness when configuring data generation settings for databases with lots of tables

New in dbForge Studio for Oracle 4.5.21 (Mar 17, 2023)

  • Improvements:
  • Added support for Linux and macOS via CrossOver
  • Code Completion:
  • Added support for the DROP FLASHBACK ARCHIVE statement
  • Added support for the CREATE RESTORE POINT statement
  • Added support for the DROP RESTORE POINT statement
  • Added support for the SET ROLE statement
  • Added support for the CREATE FLASHBACK ARCHIVE statement
  • Added support for the RENAME statement
  • Added support for the SET CONSTRAINT(s) statement
  • Added support for the FLASHBACK TABLE statement
  • Added support for the TRUNCATE CLUSTER statement
  • Added support for the EXPLAIN PLAN statement
  • Added support for the following SQL*Plus commands: ACCEPT, DEFINE, REMARK, CONNECT, EXIT, PROMPT, and VARIABLE
  • Extended support for the SELECT statement by adding support for the following clauses and subclauses: row_pattern_clause, hierarchies_clause, window_clause, flashback_query_clause (extended), modify_external_table_properties, and LATERAL Inline Views
  • Extended support for the INSERT statement by adding support for the subquery factoring clause
  • Data Compare:
  • Added the Ignore IDENTITY columns option for data comparison and synchronization
  • Added the /schemaexport and /schemaimport switches for command-line operations
  • Data Generator:
  • Added the /schemaexport and /schemaimport switches for command-line operations
  • Documenter:
  • Added support for the Memory Table property
  • Added ValidityPeriod for tables
  • Schema Compare and Table Designer:
  • Improved the behavior of table columns reordering
  • User-reported and internal bug fixes:
  • Resolved an issue with the synchronization between a column and a sequence (D89273)
  • Resolved an issue causing the application to crash upon closing the Trigger editor (D102662)
  • Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL (D110980)
  • Resolved an issue with manual product activation (D99323)
  • Fixed a bug causing the application to crash upon launch (D113391)
  • Improved Data Viewer in Data Compare to allow for viewing large LOBs (D19502)
  • Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor (D98727)
  • Improved the behavior of the 'Include physical attributes' option for unique keys in Schema Export (D93066)
  • Enhanced Database Explorer with the support for displaying DML triggers created in other schemas (T306811)
  • Improved the behavior of the 'Include database name in script' option when using templates in Data Export (D92710)
  • Improved the behavior of the 'Generate comments in the script' option in Schema Export (D92598)
  • Improved the generation of the PCTFREE property synchronization script in Schema Compare (D89274)
  • Fixed a bug in Master-Detail Browser (D105719)
  • Resolved an issue with the generation of the synchronization script when the 'Default value ON NULL' option is enabled in Table Editor (u43214109)
  • Fixed the highlighting of built-in functions (D110029, D109918)
  • Fixed an issue with the formatting of packages (D106666)
  • Fixed an issue with the formatting of the AT TIME ZONE expression (D106766)
  • Fixed a bug that occurred when describing partitions in Schema Compare (D96302)
  • Fixed a bug that occurred when refreshing Database Explorer (D94785, D94784)
  • Fixed an issue with the formatting of the subquery factoring clauses (D81274)
  • Resolved an issue causing the application to freeze during package formatting (D81274)
  • Fixed an error with importing data from Excel (D81112)
  • Fixed a bug that occurred when exporting data from the results grid to Excel (D103683)
  • Fixed an issue with getting the value of an array element in the Debugging mode (D80548)
  • Fixed an issue with incorrect case selection when formatting variables (D100932)
  • Fixed a bug that occurred when generating DDL triggers (D96143)
  • Resolved an issue where a part of the script was mistakenly included in the TODO comment while formatting (D95810)
  • Fixed a number of issues that occurred when working with queries containing aggregate functions in Query Builder (D88397)
  • Fixed an error that occurred when attempting to save a schema comparison project with a name that exceeds system limits
  • Improved the error diagnostics in Schema Compare
  • Implemented the actual values of sequences in the data synchronization script

New in dbForge Studio for Oracle 4.4.64 (Jul 19, 2022)

  • User-reported and internal bug fixes:
  • Fixed compatibility issues with the latest Windows 11 updates.
  • Fixed an error that occurred when generating a comparison report from the command line.

New in dbForge Studio for Oracle 4.4.63 (Jul 18, 2022)

  • Fixed compatibility issues with the latest Windows 11 updates
  • Fixed an error that occurred when generating a comparison report from the command line (Dd80591)

New in dbForge Studio for Oracle 4.4.56 (May 23, 2022)

  • Fixed a problem with launching the Start Page (D63348)
  • Fixed syntax error that occurred during script formatting (D77776)
  • Fixed an error with losing triggers when rebuilding a table when synchronizing schemes (D78703)
  • Fixed an error that occurred when working with the editor in the SQL document (D80821)

New in dbForge Studio for Oracle 4.4.51 (Mar 28, 2022)

  • Fixed an issue that blocked the program from being installed on specific environments due to the shell folder constant expansion failure (Z75346)
  • Fixed a critical error that occurred because of the editor cursor initialization failure when running under Microsoft Windows 11 Build 22567 and later
  • Fixed a critical error that occurred when painting the main window of the program on high resolution displays (Z81995)
  • Resolved an issue that caused the program license reactivation process after the BIOS update to fail

New in dbForge Studio for Oracle 4.4.49 (Feb 4, 2022)

  • Fixed an error that occurred when formatting a package (Z52313)
  • Fixed the display of the Invalid Object Manager document in the dark mode (Z74922)
  • Fixed an unexpected exception that occurred when closing a document that was modified in an external editor
  • Fixed the behavior of the application installer when checking the version of the .NET Framework
  • Fixed an issue with comparing objects in Data Compare
  • Fixed an error that occurred when executing a query
  • Fixed an issue with retrieving table metadata (Z77642)

New in dbForge Studio for Oracle 4.4.40 (Jan 17, 2022)

  • Connectivity:
  • Added support for Oracle 21c
  • Code Completion:
  • Added support for the SQL*Plus DESCRIBE command
  • Data Compare:
  • Updated the Report Wizard
  • Schema Compare:
  • Added the Ignore MAXVALUE option
  • Added the Ignore INCREMENT BY option
  • Added the Ignore CACHE option
  • Added the Ignore CYCLE option
  • Improved the behavior of the Ignore START WITH option
  • Drastically improved reports
  • Documenter:
  • Added support for the JSON search index
  • Added attribute clustering support
  • Other improvements:
  • Added support for nested tables in Generate Script As
  • Expanded the Generate Script As settings with 4 new options: Include COMMIT, Include SET SQLBLANKLINES ON, Include SET DEFINE OFF, and Include NLS parameters for the current session
  • Improved the behavior of the Retrieve Data option
  • Updated integration with version control systems
  • User-reported and internal bug fixes:
  • Fixed an issue with forced addition of quotes to generated aliases when they are output in lower case (T268614, T283221, T283533, T283453, T297378, T305217)
  • Added support for the conditional compilation expressions in syntax check (Z63082)
  • Added support for PL/SQL declarations in CTE expression syntax (Z64259)
  • Added support for the CROSS APPLY operator in the SELECT statement syntax (Z71607)
  • Fixed comparison of packages containing a schema name (Z60952)
  • Fixed an error that occurred when generating a synchronization script with the PL/SQL blocks (Z60143)
  • Fixed an error that occurred when activating the application (Z69522, Z63348)
  • Fixed display of materialized views in Database Explorer (T268372, T268822)
  • Fixed an issue with displaying the list of partitions in the table editor in the dark skin mode
  • Fixed an issue with displaying relationships between tables in the Database Diagram
  • Fixed an issue with accessing the System.Net.Http assembly when starting the application
  • Fixed an issue with sending error reports from an application without an installed email client

New in dbForge Studio for Oracle 4.3.99 (Oct 20, 2021)

  • The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
  • Fixed a critical error occurred when comparing data

New in dbForge Studio for Oracle 4.3.97 (Aug 16, 2021)

  • Issue with editing invalid objects (Z62052)
  • Issue with connecting to Oracle 8 using the enabled Unicode option (Z61038)

New in dbForge Studio for Oracle 4.3.93 (Jul 16, 2021)

  • Issue with filtering in Database Explorer
  • Error when establishing connection in the Direct modе (T320056, Z49673, Z51631, Z53233, Z53567, Z55028)
  • Issue with the search operation in the view editor
  • Improved processing of the error that occurred when executing cursor scripts
  • Improved capabilities for opening a connection for users with limited permissions (Z57215)
  • Improved behavior of the context menu on the Constraints tab of the table editor (Z55316)
  • Error with the use of virtual columns (Z55233)
  • Improved capabilities of work with the SQL*Plus DEFINE command (Z51391)
  • Improved behavior of alias renaming for view columns (T322738)
  • Improved application of parameters when executing scripts by using the F5 and F8 commands
  • Issue with cell focus in Data Editor
  • Issue with parameter recognition during the execution of scripts (T303259)
  • Unexpected exception when importing data from an Excel file (T314153)
  • Error when restoring documents
  • Unexpected exception when describing indexes during the generation of documentation (Z52662)
  • Added processing of the circular dependency between the calculated column and the function (Z58806)
  • Error while loading assemblies (Z52346)
  • Mapping reset error during comparison with Custom Query (Z53285)
  • Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns (Z52174)
  • Data comparison error that occurred when working with BYTE columns (Z51637)
  • Fixed processing of errors that occurred as a result of multi-threading
  • Issue with using Find and Replace in the object editor
  • Issue with procedure text modification during debugging
  • Issue with license verification on launch
  • Issue with creating JOIN connections in Query Builder
  • Added capability to set the time for input parameters of the DATE type in stored procedures
  • Error that occurred when opening documents

New in dbForge Studio for Oracle 4.3.34 (Jan 28, 2021)

  • New features and improvements:
  • Activation of the tool via the command-line interface
  • Improved working with virtual columns when comparing and synchronizing schemas
  • User-reported and internal bug fixes:
  • Issue with synchronizing unique keys when modifying columns (T321087, T322045)
  • Index analysis error when modifying a table (T324838)
  • Working with index metadata is corrected
  • Error when copying data from Data Editor (T319036, T319061, T319090, T319180, T319304, T320387, T320393, T320831, T321857, T323218)

New in dbForge Studio for Oracle 4.2.34 (Sep 29, 2020)

  • Complete server version for Oracle 18 and higher was detected incorrectly
  • The 'SQL command not properly ended' error occurred with the delimiter character when executing the WITH clause (T312408)
  • Behavior when copying the cell values from Data Editor is improved
  • Issue with detecting the difference between tablespaces in constraints is eliminated
  • Issue with the correct use of tablespaces in constraints when the Ignore Tablespaces option is enabled is eliminated (T306592)
  • Error occurred with describing columns (T304630, T304631)
  • A query that left-joined a table that was inner-joined with another table using parentheses to override the default precedence could not be formatted
  • Formatting of a broken XLS file when exporting data to EXCEL is fixed
  • Quoting when exporting data of the DATE format to EXCEL is improved (T313769)
  • An error with closing the SQL document is eliminated

New in dbForge Studio for Oracle 4.2.20 (Sep 17, 2020)

  • New features and improvements:
  • Connectivity support for Oracle 20c is implemented
  • New 'Reseed identity column' data sync option is added
  • User-reported bugs fixed:
  • Other user-reported bugs are fixed (T311478, T307976, T306749, T306316, T305663, T305049, T302881)

New in dbForge Studio for Oracle 4.1.48 (May 8, 2019)

  • User reported bugs fixed:
  • Problem with lost synchronization script is fixed (ORCL-2075)
  • Problems with foreign keys comparing are fixed (Т280909, T281587)
  • Other minor user reported bugs are fixed

New in dbForge Studio for Oracle 4.1.43 (Apr 16, 2019)

  • New features and improvements:
  • Brand New Application Skins
  • Support for Oracle 19c
  • AutoCommit Mode ON/OFF
  • Improved Schema Comparison Performance
  • Transaction Reminder and Execution Notifications
  • User reported bugs fixed:
  • Problem with incorrect temporal table name is fixed (T277821)
  • Problem with wrong message in formatter is fixed (T277972)
  • Problem with ignore collation option is fixed (T276888)
  • Problem with Syntax Check is fixed (T275687)
  • Problem with Generate Fully Qualified Object Name option is fixed (T243422)
  • Problems with describe objects in Data Compare are fixed (T270693, T277985)

New in dbForge Studio for Oracle 4.0.304 (Dec 29, 2018)

  • Problem with option "Generate fully qualified object names" is fixed (T243422)
  • Incorrect description of system properties is fixed (T268296)
  • Incorrect description of database object is fixed (T270693)
  • Problems in schema comparison wizard are fixed (T268590, T269556)
  • Problem with restoring *.dbd file is fixed (T268762)
  • Materialized view creation issue is fixed (T268296)
  • Data rows addition issue is fixed (T267838)
  • Problems with pressing "Refresh" button in "Breakpoints" window are fixed (T267575, T267762, T270071, T271464)
  • Problem with retrieving data from table is fixed (T272124)

New in dbForge Studio for Oracle 4.0.275 (Oct 30, 2018)

  • Cashed updates mode issues are fixed (T267355, T266501)
  • Debugger issues are fixed (T265499, T267117, T267575)
  • Query builder issue is fixed (T266232)
  • Other user reported bugs are fixed (T267382, T265499, T265029)

New in dbForge Studio for Oracle 4.0.237 (Sep 21, 2018)

  • Enterprise Editon:
  • Data Generator
  • Database Documenter
  • Connectivity:
  • Support for Oracle 18c
  • SQL Document:
  • CTRL+W shortcut for closing the current tab
  • Opening new tabs next to current one
  • Pressing CTRL+N in an SQL window lets the new window to inherit the server and database of the current window
  • Displaying a connection color in the status bar
  • Each document creates its own connection
  • The Close All Unmodified Tabs command is added
  • Format Document (CTRL+K+D) command in the shortcut menu of SQL document
  • Highlight of the matching columns and data in INSERT statement
  • Close 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:
  • Displaying 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
  • Detecting of column types when importing data from Excel format
  • Schema Comparison:
  • Extended Comparison Reports functionality
  • Schema 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
  • Ignore Supplemental Log
  • Ignore Flashback Archive
  • Ignore materialized view START WITH value
  • Ignore character length semantics
  • Ignore ILM Policies
  • Ignore sequence START WITH value
  • Ignore Sequence MinValue
  • Schema 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
  • 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:
  • Extended Comparison Reports functionality
  • Exclusion and Inclusion of columns from/into comparison
  • Automatic selection of comparison key for objects without equal unique indexes
  • Pre and post script execution during data synchronization
  • 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 the middle of varchar
  • Always exclude newly added objects
  • Ignore datatype for virtual columns
  • Data Tolerance interval
  • Data synchronization options:
  • Check for concurrency updates
  • Synchronize current values of sequences
  • 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
  • Support for High DPI and 4k resolution is improved
  • User reported bugs fixed:
  • Lost connection issues are fixed (T262566, T195020, T205502, T228904, T233605, T241200)
  • Problem with incorrect script to update complex key is fixed (T261854)
  • Compatibility with Windows Platform FIPS validated cryptographic algorithms is improved (T226564, T231229, T257670, T260673, T202683)
  • Problem with Security Manager is fixed (T256960)
  • Problems with Save as my defaults are fixed (T257360, T260045, T262519, T263615)
  • Problems with NRE are fixed (T163054, T175176, T205363, T196813, T199194, T208875, T218758, T229140, T201029, T225559, T203414, T212302, T213582, T227486, T213625, T236448, T236923, T238693, T248205, T228159, T230121, T249362, T253487, T254623, T262154, T253153, T246452, T247267, T247603, T248251, T246253)
  • Problem with data export to Excel is fixed (T247402)
  • Retrieve data issue is fixed (T249178)
  • Default values comparison issue is fixed (T237731)
  • Incorrect behavior during script execution issue is fixed (T230057)
  • Paginal mode issue is fixed (T212450)
  • Toolbar options issues are fixed (T203593, T199057, T198336)
  • Problems with package execution are fixed (T202596, T242554, T254263, T254704)
  • TIMESTAMP and CHAR view issues are fixed (T196674, T194418)
  • Trigger editor issue is fixed (T184056)
  • Command line issue is fixed (T172991)
  • Table data search issue is fixed (T168850)
  • Other user reported bugs are fixed (T145649, T83470, T161112, T140586, T198392, T199685, T192984, T193836, T195773, T251820, T200202, T200857, T211898, T243644, T31026, T226980, T224189, T223945, T214816, T213692, T222189, T214816, T215979, T232587, T237252, T210590, T239389, T250788, T210052, T210976, T30940, T262538, T253996, T248605, T247741, T261132, T214816)

New in dbForge Studio for Oracle 3.10.12 (Apr 24, 2017)

  • User reported connection issues are fixed (T214018, T215630)

New in dbForge Studio for Oracle 3.10.10 (Apr 6, 2017)

  • dbForge Studio for Oracle Supports Connectioon to Oracle Database 12c Release 2
  • Issue with NUMBER type in Data Editor and Viewer is fixed

New in dbForge Studio for Oracle 3.9.22 (Oct 25, 2016)

  • The Database Search tool has been completely redesigned for optimal search of both objects and data
  • Visual Object Editors have been totally redesigned
  • Virtual Columns are now supported in Visual Object Editors and Schema Compare
  • Greatly improved suggestion performance
  • Improved XML View and new JSON View for Data Editor and Viewer Window
  • Generate Script As now supports selection of multiple objects
  • Styled icons are used by default.

New in dbForge Studio for Oracle 3.8.50 (Feb 23, 2016)

  • Minor improvements
  • User reported bug fixes (T159641)

New in dbForge Studio for Oracle 3.8.40 (Feb 23, 2016)

  • New features and improvements:
  • Redesigned UI for schema compare and data compare functionality
  • Support for TFS 2015 in schema compare
  • Find and recompile invalid objects
  • Server connection via IPv6
  • Shortcut table
  • Code Refactoring: changing all occurrences of variable names and object names to new ones, automatically finds and corrects all references to them
  • Redesigned Installation Wizard
  • User reported bugs fixed:
  • Windows Authentication connection is added
  • InvalidCastException related to script editing is fixed (T157328)
  • An editor problem with using dblink in a query is fixed (T156854)
  • Object suggestion is fixed when a parenthesis is not closed in the function parameter list (T156402)
  • IndexOutOfRangeException related to sorting negative values is fixed (T150652, T147852, T138076)
  • An error related to the shortcut menu invocation in the Database Explorer in the Express Edition is fixed (T149585)
  • FormatException related to selecting many tables in the Data Export is fixed (T148012, T154090)
  • ArgumentException when trying to close the application is fixed (T146115)
  • IndexOutOfRangeException related to the Direct connection without the client is fixed (T145799)
  • InvalidOperationException related to exporting a large amount of strings in XML is fixed (T143979)
  • NullReferenceException related to clearing the Temp directory with a third-party tool is fixed (T142845)
  • InvalidOperationException related to script editing is fixed (T141994)
  • The 'ORA-01805' message related to editing tables with triggers is fixed (T135730, T140586)
  • An error related to 'TRUNC(SYSDATE, 'MM')' function is fixed (T137279)
  • A comment is saved now while adding a column via diagram (T134905)
  • NullReferenceException related to navigating to the latest data page in a huge table (11 M records) is fixed (T134857, T139908, T143868, T152029)
  • A problem related to saving the custom table mapping is fixed (T132161)
  • An exception related to saving a string that exceeds the field size is fixed (T127748, T128814, T129413, T129430, T129536, T129840, T136003, T130044, T130265, T130669, T130761, T129840, T131388, T131480, T131780, T139474, T140088, T140504, T143275, T145931, T146842, T150684, T151508, T155575, T156143, T156146, T157185, T157485)
  • InvalidCastException related to exporting data to sql defined by a template is fixed (T125915)
  • The time display is corrected while executing a long-running query (T125376, T133313)
  • An exception related to clearing a column with the not null constraint is fixed (T124723, T125079, T128581, T125085, T138206, T149470)
  • AlreadyRunningException while restarting a long-running query is fixed (T124934)
  • NullReferenceException while editing and clicking on Filter after staring data comparison is fixed (T124067)
  • It is possible to connect to Oracle 7.3.4 Server using direct mode (T123879)
  • An exception while editing a primary key of one record is fixed (T123754, T124088)
  • The 'Value was either too large or too small for an Int64' message while profiling a long-running query is eliminated (T120788)
  • NullReferenceException while opening a corrupted configuration file is fixed (T115750)
  • Conflict Records showing non-existent records is fixed (T150215)
  • Formatter Exceptions are fixed
  • Database Projects allow using all the types supported by the SQL editor
  • A problem related to query execution while changing the connection is fixed

New in dbForge Studio for Oracle 3.7.472 (Feb 4, 2015)

  • Stability improvements and bug fixes
  • User reported bug fixes

New in dbForge Studio for Oracle 3.7.468 (Jan 27, 2015)

  • SQL Editing and Execution:
  • Suggestion and formatting of MERGE statements
  • Command-line interface for SQL formatting
  • Query execution pane
  • Option to change a snippets folder location
  • Phrase completion
  • Option to set files encoding within the /execute and /schemaexport command-line operations
  • Data Comparison and Sync:
  • Ignore difference in end of line option
  • Show white spaces option
  • Data Export and Import:
  • Export to the Excel 2007 (XLSX) format
  • Retaining records filtering when the Export Selected Rows Only option is selected
  • Export of BLOB fields as TEXT to Excel, TXT, HTML, PDF, RTF, and CSV formats
  • Export to Excel, RTF, PDF with/without a header
  • Force quotes option when exporting data to a CSV file
  • Option to select encoding when exporting to DBF
  • Import of dynamic values from Excel and Excel 2007
  • Detecting column types when importing data from the CSV format
  • Data Report:
  • Support of report parameters in the command-line interface
  • Database Explorer:
  • Sending objects to a database diagram
  • Generate Script As shortcut menu item for check constraints
  • Renaming columns, indexes, default and check constraints
  • Updated unique key and primary key editors
  • Data Editor:
  • Easy way to hide data results
  • Data Viewer and LOB Editor are combined in a single control
  • Redirect Data to Output is transformed into additional data editor
  • Other Features and Improvements:
  • Support of multiple monitors
  • Create Schema Snapshot and Data Report wizard windows are modeless
  • Enhanced Find and Replace window
  • On-line documentation

New in dbForge Studio for Oracle 3.6.389 (Jul 17, 2014)

  • Database Connectivity:
  • Connection via Windows authentication is added
  • Database Explorer:
  • Ability to compile objects from object category node is added
  • Ability to enable/disable triggers is added
  • Ability to enable/disable indexes is added
  • Icons for user types and triggers are updated
  • Schema Compare and Synchronization:
  • Ignore Schema Name During Comparison option is added
  • Ignore Compression Differences option is added
  • Ignore LOGGING/NOLOGGING Clause option is added
  • Ignore Column Order in Indexes option is added
  • Exclude Comments option is added
  • Use SQL Plus Commands option is added
  • Data Compare and Synchronization:
  • Include Print Comments option is added
  • Use SQL Plus Commands option is added
  • Data Editor and Viewer:
  • Ability to view results as a structured XML file is added
  • Object Editors:
  • Viewing script while editing columns, indexes etc. is possible now
  • Code Debugger:
  • Outputting current variable value in tooltip while debugging procedures and functions is added
  • Aliases refactoring is possible now
  • User Interface:
  • Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
  • Windows connection coloring is added
  • Restoring document tabs from the last session is possible now
  • Switching between wizard window and primary window is possible now

New in dbForge Studio for Oracle 3.5.322 (Mar 5, 2014)

  • New code formatter features:
  • New Option: Enclose identifiers within square brackets []
  • New Option: Add parentheses when inserting functions
  • New Option: Enable autoformat words while typing
  • New Option: Alias Text Case - As in declaration
  • Code formatter functionality is available even if SQL Complete is disabled
  • Do not format tag is implemented. Now it is possible to format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.
  • Refresh suggestions cache:
  • Automatic refresh suggestions cache by specified time is added
  • New option: Refresh suggestions cache on detecting changes on a server
  • Minor improvements:
  • Formatting CASE options are redesigned
  • User reported bug fixes:
  • Problem with multiple open connections is fixed (R30444)
  • Problem with custom filter in the Data Editor is fixed (R32040)
  • Problem with connection's cloning is fixed (R32175)
  • Some problems with code formatter options are fixed (R31104, R30485, T93608, T96444)
  • NullReferenceException while opening project is fixed (T93935, T94966, T95798)
  • Some problems with Find and Replace text are fixed (T91956, T91956)
  • Incorrect order of minutes in the Data Editor is fixed (R30795)
  • Problem in Schema Comparison with foreign keys is fixed (T72056)
  • Incorrect behavior in Data Comparison with conflict records is fixed (T73218)
  • Ability to save Sql Document with a different extension is added (R30486)
  • ArgumentOutOfRangeException in Object Editor is fixed (T92445)
  • NullReferenceException with connection is fixed (T96035)
  • Some problems with debugger are fixed (R30706, R32105, T96047)
  • Problem with indents in text editor is fixed (R32140)
  • Incorrect behavior with "Ignore trailing spaces" option is fixed (T95602)
  • InvalidOperationException in Data Editor in editable mode is fixed (T92244)
  • Some problems with code completion are fixed (T91681, T97500)
  • Incorrect script generating for DATE data types is fixed (T97017)

New in dbForge Studio for Oracle 3.5.272 (Dec 13, 2013)

  • InvalidOperationException while editing query results is fixed
  • An exception while setting a constraint in the table editor is fixed
  • NullReferenceException while selecting the 'In Bytes' checkbox in the column properties is fixed
  • IndexOutOfRangeException while connecting to Oracle 8.0.x is fixed
  • ArgumentOutOfRangeException while creating a new folder inside the Snippet Manager is fixed
  • KeyNotFoundException while generating a schema script with all enabled options is fixed
  • Incorrect behaviour while setting custom keyboard shortcut for a command is fixed
  • NullReferenceException while opening the Security Manager is fixed
  • Incorrect values for BLOB fields while generating the INSERT statement from the Data Editor are fixed

New in dbForge Studio for Oracle 3.5.185 (Nov 27, 2013)

  • Oracle 12c is supported
  • Improved database object editors:
  • Editable column grid in the table editor now allows adding and editing columns without opening the popup dialog
  • Full-text search in the column grid in the table editor is added
  • Schema changes can now be viewed before updating database
  • Editor layout was revised, and now it allows viewing designer and table SQL simultaneously
  • F7 shortcut can now be used to toggle all editor views
  • Heuristics is supported: data type of the new column is suggested basing on the column name. For example, for CUSTOMER_ID column NUMBER data type will be suggested, and for CHANGE_DATE column DATE data type will be suggested.
  • Optimized application performance for working with Oracle servers:
  • Database Explorer works faster now
  • Database object editors work faster now
  • Metadata for code completion is described faster now
  • New code formatter:
  • Multiple formatting profiles
  • Extended options for formatting different clauses
  • Preview window for viewing formatted code with support of code highlighting and editing
  • Option quick search filter
  • Independent and precise adjustment for SQL-statements
  • Extended code completion capabilities:
  • Suggestion of JOIN statements is added
  • Extended Oracle grammar support is added
  • Context-specific suggestions are improved
  • Full support of suggestions and PL/SQL grammar with context consideration is added
  • Minor features:
  • New window docking system is introduced. Switching between tool windows on Ctrl+Tab is supported
  • Working with Oracle on Amazon RDS is possible now
  • New skins are added (Metropolis and VS2010)
  • Snapshot creation functionality is added to all product editions
  • Connection export to Import and Export settings wizard is added
  • Microsoft Windows 8.1 is supported
  • Now dbForge Studio for Orace can work with 32-bit versions of Oracle client on 64-bit versions of Windows

New in dbForge Studio for Oracle 3.1.283 (Nov 27, 2013)

  • InvalidOperationException on working with SQL document in Express edition is fixed (T75878)
  • Problem on exporting views from command line is fixed (T75081)
  • NullReferenceException on creating snapshot via command line is fixed (T74698)
  • NullReferenceException from pop-up menu of Database Explorer in Standard edition is fixed (R24654)
  • Problem with displaying import settings in the Black skin is fixed (R24554)

New in dbForge Studio for Oracle 3.1.275 (Aug 5, 2013)

  • NullReferenceException on comparing BFILE data type is fixed
  • NullReferenceException on exporting a schema in Direct Mode is fixed
  • NullReferenceException on working with an SQL document is fixed
  • NullReferenceException on navigating to a script from the Find object result window is fixed
  • An error while comparing a schema in Direct Mode is fixed
  • NullReferenceException on viewing unrepresentable data in the Data Editor is fixed

New in dbForge Studio for Oracle 3.1.270 (Jun 19, 2013)

  • NullReferenceException on searching objects by their definition text in Find Object is fixed
  • The problem with TFS in Schema Compare is fixed
  • NullReferenceException on getting schemas in Export Schema wizard is fixed

New in dbForge Studio for Oracle 3.1.260 (Apr 9, 2013)

  • NullReferenceException on changing a date field in Data Editor is fixed
  • Incorrect behaviour with inserting the Now value into the Timestamp field in Data Editor is fixed
  • The problem with punctuation's visibility in code editor with black background being set is fixed
  • Incorrect behaviour with editing selected text in code editor is fixed
  • Check boxes are now replaced with radio buttons in the Data Import wizard
  • InvalidOperationException on importing data from MS Excel in the Express edition is fixed
  • NullReferenceException on killing sessions in Session Manager is fixed
  • The ability to restart importing data with the same options in the Data Import wizard is added
  • The "Value cannot be null" message on importing data from MS Excel is eliminated

New in dbForge Studio for Oracle 3.1.251 (Jan 14, 2013)

  • On opening Connection the ORA-00933 error is received (R14892)
  • Error on displaying connection editor form is fixed (T16315)
  • Error on recurring opening of the 'Custom Queries Mapping' dialog box is fixed (T63195)
  • The 'Method is not implemented' error occurring on editing objects is fixed (T62811)
  • The Error on clicking MyDefaults in Schema Synchronization Wizard is fixed (R15446)
  • Error on saving export project is fixed (R15400)
  • Message on recurring call of 'Go To Definition' is not displayed if no changes were performed in the previous document (T14962)
  • Error 'Cannot navigate to definition' on navigating to object with 'Go To Definition' is fixed (T14956)
  • SET ROLE statement is supported (T61603)
  • Error occurring on the 'Paste As New Record' command execution is fixed (R8991)
  • The 'Empty path name is not legal' error on clicking Synchronize in the Synchronization wizard is fixed (R16854)
  • Notes for bookmarks in query results are added (T16548)
  • The 'Index was out of range' error on closing document is fixed (T62858)
  • Error on displaying results of several SELECT queries is fixed (T64570)
  • Error on generating script using Schema Export utility is fixed (T61285)
  • Message displayed on generating argument file is changed (T16317)
  • Error on opening window with subquery by foreign key is fixed (T63953)
  • Ability to set service name in connection manager is added (T62012)
  • Pstart and Pstop columns are added to the Explain plan (T61893)

New in dbForge Studio for Oracle 3.1.243 (Nov 20, 2012)

  • Problem with hidden buttons in the Schema Comparison wizard is fixed
  • Problem with launching the application through the command line via MSBuild is fixed
  • Problems with profiling a query that followed by a comment is fixed
  • ExternalException in GDI+ on typing text in SQL document is fixed
  • NullReferenceException on comparing selected profiling results in SQL Profiler is fixed
  • Problem that occured on changing and then compiling a package is fixed
  • KeyNotFoundException on viewing changes in the Role editor is fixed
  • NullReferenceException on adding hyperlink on a database diagram is fixed
  • MissingMethodException on importing schema via the Schema Import wizard is fixed
  • NullReferenceException on deploying a database project is fixed
  • NullReferenceException on changing a layout in Query Builder is fixed
  • Incorrect behaviour with removing the selected text in SQL document on closing the Edit Parameters dialog is fixed
  • InvalidCastException on filtering data in Data Editor is fixed
  • Incorrect determining of the DBA role for connected user is fixed
  • NullReferenceException on loading invalid snippets in Snippet Manager is fixed
  • Incorrect generation of password value in Security Manager is fixed
  • ArgumentNullException on refreshing snippets in the Code Snippets window is fixed
  • InvalidOperationException on refreshing data in the Pivot designer is fixed
  • Non-working main menu after selecting several connections in Database Explorer is fixed
  • Incorrect behaviour with cycled dependencies between object and table types during schema comparison is fixed
  • Incorrect generation of view's text on generating script is fixed
  • Incorrect behaviour with foreign key properties after deleting and recreating this key is fixed
  • NullReferenceException on parsing invalid expressions in WHERE clause in Query Builder is fixed
  • Problem with updating data in a view with INSTEAD OF trigger on it is fixed

New in dbForge Studio for Oracle 3.1.219 (Nov 20, 2012)

  • Error "The path is not of a legal form" is fixed
  • Problem with combo boxes in the synchronization wizard is fixed
  • Message "triggers were deleted" after database modification is fixed
  • Error "PS:00123 program too large" during synchronization with disabled option "Synchronize LOBs via files" is fixed
  • Application crash after switching to the tab "text" for view in the object viewer is fixed
  • Problem with selection after increase line indent is fixed
  • Bug displaying function parameters in the quick info is fixed
  • Bug displaying package parameters in the quick info is fixed
  • Error "PLS-00103" after execution current statement is fixed
  • Error "Unable to profile this query" is fixed
  • Error "ORA-01013" during execution DML with execution timeout is fixed
  • Problem with new schema comparison window is fixed
  • Problem with displaying public database links is fixed
  • Error "The handle is invalid" during executing command line via msbuild is fixed

New in dbForge Studio for Oracle 3.1.206 (Jun 21, 2012)

  • Problems with navigation to functions in packages are fixed (R6159)
  • Error Report on the Compile References command is fixed (T40847)
  • Error Report on dragging a document is fixed (T40368)
  • Problem with single-clicking an object in Database Explorer leading to opening Object Editor is fixed (R9995)
  • Text of the message that pops up when compiling packages is fixed (T39879)

New in dbForge Studio for Oracle 3.1.198 (May 23, 2012)

  • Schema synchronization scripts for Logging and Compress table options is fixed
  • Error report during SQL script execution is fixed
  • Problem with Ignore trailing spaces option in Data Comparison wizard is fixed
  • Problem with disabled Data Editor is fixed
  • Problem with paramater parsing in SQL document is fixed

New in dbForge Studio for Oracle 3.1.196 (May 2, 2012)

  • New Features:
  • Report generation options were added to Command line
  • User reported bug fixes:
  • OutOfMemoryException on comparing big schemas is fixed
  • Error report during SQL script execution is fixed
  • Problem with constraints describe on Oracle 7 is fixed
  • Script generation option "List individual hash partitions" is turned on by default
  • NullReferenceException on describing schema objects is fixed
  • NullReferenceException on deleting trigger from "Used By" section is fixed
  • Problem with unexpected application termination when searching objects is fixed

New in dbForge Studio for Oracle 3.1.190 (May 2, 2012)

  • Issue when Error List isn't cleared on executing query with errors is fixed (R5686)
  • Few problems with showing differences in Schema Compare document are fixed (T31850)
  • NullReferenceException on entering some letters in SQL editor is fixed (R6116)
  • The problem with 'groupby' option in command line for /schemacompare switch is fixed (T34566)
  • The problem with setting a filter for large fields in Data Editor is fixed (T35222, T35564)
  • ArgumentNullException on comparing schemas on a single connection is fixed (R6134)
  • The problem with launching installation on x64 operating systems is fixed (R6264)
  • Sending extra queries on switching document view in the view editor is fixed (R6186)
  • Incorrect navigation to package methods if they contain comments is fixed (R6159)
  • Problem with losing aliases on editing invalid views is fixed (R6183)
  • NullReferenceException on mapping objects in Data Comparison wizard is fixed (R7172)
  • Incorrect behaviour of the "Include storage clause" option in Generate Schema Script wizard is fixed (T36006)
  • Problem with hiding the "Loading Data" label is fixed (R6275)
  • NullReferenceException on schema export is fixed (R7189, R7099)
  • InvalidCastException on exporting data from RAW columns to SQL is fixed (R7178)
  • IndexOutOfRangeException on selecting text in SQL Document is fixed (R6054)
  • Problem with showing columns in Code Completion in project's SQL document is fixed (T35460)
  • ArgumentOutOfRangeException on showing Code Completion window is fixed (T36319, T36399, T36532)
  • OutOfMemoryException on toggling bookmarks in SQL document is fixed (R6055)
  • Incorrect behaviour with displaying bookmarks on editing text in SQL document is fixed (R6053)
  • Incorrect search of text occurrence in SQL Document is fixed (R6831)
  • Duplicating a trigger on renaming it in Database Explorer is fixed (R7139)
  • ArgumentException on changing a schema in Data Compare document in the Express edition is fixed (T36990)
  • NullReferenceException on executing a statement in SQL Document is fixed (R7601)
  • Wrong message about a trigger on saving a table is fixed (R7109)
  • NullReferenceException on editing data in Date columns in Data Editor is fixed (T36314)
  • NullReferenceException on closing Schema Compare wizard is fixed (R7095)
  • OutOfMemoryException on mapping objects in Data Comparison wizard is fixed (R7717)
  • InvalidOperationException on comparing data through command line is fixed (R7720)
  • Problems with showing differences in Schema Compare document are fixed (T31850)
  • Incorrect navigation to package functions and procedures is fixed (T36445)
  • ArgumentException on comparing data is fixed (T36783, T37302)
  • Problem with showing errors in command line during data comparison is fixed (R7180)
  • Problem with creating report about comparison is fixed (T31803)
  • InvalidCastException on editing DATE fields in Data Editor is fixed (R7325)
  • InvalidOperationException on comparing data through command line is fixed (R7096)
  • ExternalException on generating script of data comparison results is fixed (T34820)
  • NullReferenceException on comparing data through command line is fixed (R7008)
  • ArgumentOutOfRangeException on showing Code Completion window is fixed (T36316, T36399)
  • Errors on executing a script through the Execute Large script wizard are fixed (T36959)
  • NullReferenceException on describing triggers is fixed (T37500, T38016)
  • NullReferenceException on comparing XML schemas is fixed (R7175)
  • Schema synchronization scripts are generated correctly now (T37909)
  • ArgumentException on comparing data is fixed (T37864)
  • Wrong behaviour with unstable network in Data Editor is fixed (T35784)
  • Incorrect comparing of index properties is fixed (T37581)
  • Incorrect generation of records in log file during schema comparing is fixed (T36928)
  • Path for comparison report is saved now (T37373)

New in dbForge Studio for Oracle 3.1.172 (Dec 23, 2011)

  • A few problems with Code Completion and Quick Info are fixed.
  • FormatException on installing the product is fixed
  • Problem with inserting keywords from the Code Completion window is fixed ArgumentException on exporting data of table with invalid name is fixed

New in dbForge Studio for Oracle 3.1.170 (Dec 14, 2011)

  • Several problems in Express edition are fixed
  • Several problems with Code Completion are fixed
  • One SQL document is opened on invoking the Retrieve Data command for several selected tables in Database Explorer now
  • NullReferenceException on opening the Document Outline window is fixed
  • ArgumentOutOfRangeException on filtering or refreshing data in Data Editor is fixed
  • InvalidCastException on filtering data in Data Editor is fixed
  • RowNotInTableException on saving changes after working in cashed updates mode is fixed
  • NullReferenceException on closing application with opened Object Viewer is fixed
  • NullReferenceException on inserting SQL code into text editor is fixed
  • IndexOutOfRangeException on inserting a snippet into code editor is fixed

New in dbForge Studio for Oracle 3.0.165 (Dec 8, 2011)

  • New Features:
  • 150 improvements in the code autocompletion system
  • Oracle SQL and PL/SQL syntax support is expanded
  • Work of quick info hints for schema objects is improved
  • Keywords case is changed automatically on typing (if the corresponding options are set)
  • Usability shortcomings and errors are fixed
  • SQL document works with additional PL/SQL file types:
  • Support for editing .pls, .plb, .pks, .pkb, .pck Oracle PL/SQL files is added
  • Support for editing files with PL/SQL code created in some competitors' products is added
  • Data export to SQL statements
  • Possibility to export data to INSERT, UPDATE, DELETE, and MERGE statements is added
  • Data can be exported from a table or data grid using a wizard
  • Quick export from data grid without opening wizard
  • Convenient work with result sets of several SELECT queries
  • If there is more than one SELECT statement in a document, after execution query results will be displayed on separate tabs in the Data window.
  • Such approach allows working with each data set independently.
  • Editing data of object fields
  • The new product version provides possibility to edit data in object fields in tables using a pop-up editor.
  • Support for editing temporary tables
  • There is a capability to create and edit temporary tables in Table Editor.
  • Document Outline window for code navigation is improved
  • Grouping nodes by IF, FOR, etc. flow-control statements blocks is added
  • Displaying labels and navigation among them is added
  • More convenient working with query execution plan
  • Quick query plan obtaining (without turning the Profiling mode on) is added
  • Displaying of the EXPLAIN PLAN results without creating an additional table in the user's scheme is added
  • Performance improvements
  • Time required on application startup and connection opening is reduced
  • Building of the Database Explorer tree, refreshing it, and receiving table list is quicker now
  • Getting metadata for code completion becomes faster
  • Work of Schema Export with large amount of objects and data is improved
  • Data Editor working speed is increased
  • Object Viewer and Property Browser windows working speed is increased
  • Navigation to schema object editors from code is improved
  • Win-x64 Native Support
  • Now the application does not require 32-bit Oracle client software installed when working with 64-bit Windows operating system - the application works with 64-bit Oracle client software.
  • User reported bug fixes:
  • InvalidOperationException on expanding hierarchy in Security Manager is fixed
  • Few errors on describing server scope objects are fixed
  • ArgumentOutOfRangeException on showing the Code Completion window is fixed
  • Schema compare command line option to compare snapshots is added
  • OutOfMemoryException on restoring and backing up a schema is fixed
  • Incorrect outlining of PL\SQL code is fixed
  • NullReferenceException on editing WHERE condition in Query Builder is fixed
  • NullReferenceException on showing results in SQL document is fixed
  • Incorrect clipboard operation on working with master-detail document is fixed
  • Incorrect generating of the TRIM function in Query Builder is fixed
  • Few errors of showing quick information are fixed
  • NotImplementedException on trying to save template in Schema Export wizard is fixed
  • NullReferenceException on retrieving data containing Oracle objects is fixed
  • Problem with exporting negative numbers to CSV is fixed
  • ORA-00600 on showing LOB data is fixed
  • Problem with Find Object window when working on several displays is fixed
  • Showing wrong execution plan is fixed
  • NullReferenceException on editing a query in Query Builder is fixed
  • Execution of package's function or procedure is fixed
  • Wrong behaviour with commiting Code Completion on TAB or whitespace is fixed
  • Ability to specify the length of VARCHAR column in bytes is added
  • InvalidOperationException on typing CREATE TYPE in SQL document is fixed
  • Wrong parsing of current statement in script is fixed
  • NullReferenceException on viewing Conflict records in data comparison documents is fixed
  • Incorrect time of query execution is fixed
  • The wrong behaviour with computed columns on schema comparison is fixed NullReferenceException with parsing script on opening SQL file is fixed
  • InvalidCastException on exporting data to XML from Data editor is fixed
  • Wrong behaviour with parsing parameters in SQL document is fixed
  • ArgumentOutOfRangeException on synchronizing schemas in Schema Comparer is fixed
  • OutOfMemoryException on comparing schemas is fixed
  • ArgumentException on trying to edit object via context menu in schema comparison document is fixed
  • Named parameters are supported
  • ArgumentOutOfRangeException on refreshing array types in Database Explorer is fixed
  • Fake cycling in schema comparison is fixed
  • Hanging on data comparison is fixed

New in dbForge Studio for Oracle 3.0.105 (Oct 6, 2011)

  • FormatException on getting information for partitioned table in Project Wizard is fixed
  • NullReferenceException in Import Utility Wizard is fixed
  • The problem with trial period is fixed
  • The problem with intellisense after entering text is fixed
  • The problem with Edit Mask form is fixed
  • Some errors with intellisense are fixed

New in dbForge Studio for Oracle 3.0.103 (Sep 20, 2011)

  • InvalidCastException on expanding nodes in Database Explorer in the Express edition is fixed
  • NullReferenceException on getting column list for a table on a SYSDBA connection is fixed
  • The problem with showing trial form when 14 days left to expire a license is fixed
  • NullReferenceException on showing Quick Info hint for a PL\SQL variable is fixed
  • Incorrect synchronization of Supplemental Logs is fixed
  • Incorrect describing of clustered columns is fixed
  • NullReferenceException on editing data in Data Editor is fixed
  • IndexOutOfRangeException on adding new records in Data Editor is fixed
  • ORA-00933 error on Oracle server 8.1.7 is fixed
  • NullReferenceException on removing a table from diagram in Query Builder is fixed
  • NullReferenceException on sending custom snippets to Devart is fixed
  • NullReferenceException on editing a data for TIMESTAMP column is fixed
  • Incorrect displaying packages in Document Outline on working with Database Designer is fixed
  • InvalidOperationException on double clicking on foreign key on Database Diagram is fixed
  • Opening different instances of product documentation is fixed
  • TypeLoadException on executing queries on .NET Framework 2.0 is fixed
  • NullReferenceException on editing CLOB data in the card view of Data Editor is fixed
  • ArgumentOutOfRangeException on showing Code Completion window is fixed
  • Options for changing keywords and identifiers case for Code Completion are added
  • Profiler options are added in Options dialog

New in dbForge Studio for Oracle 3.0.96 (Sep 2, 2011)

  • A few new tasks and some improvements are made in the Quick Info feature
  • Import of old connections from OraDeveloper Studio is added
  • The "Suggest feature" command is added to the Help menu
  • Some improvements in Code Completion feature for PL\SQL blocks are made
  • ORA-00942 on enabling or disabling a constraint in Database Explorer is fixed
  • NullReferenceException on trying to create a new snapshot in the Schema Comparison wizard is fixed
  • NullReferenceException on creating a new document is fixed
  • ArgumentOutOfRangeException on editing SQL text in the SQL document during execution is fixed
  • The problem with cut label texts in the Options dialog is fixed
  • Wrong behaviour of the "Execute current statement" command is fixed
  • IndexOutOfRangeException on indenting selected text in Code Editor is fixed
  • ORA-02003 on getting results of SQL profiling is fixed
  • Application's hanging on schema exporting is fixed
  • Showing incorrect parameters for built-in functions is fixed
  • Unavailable TFS client on choosing a version control alias in the Schema Comparison wizard is fixed
  • Some improvements are made in Document Outline window
  • A few fixes for correct version control properties setting are made
  • Incorrect generating of CREATE VIEW text is fixed
  • The problem with showing the context menu in Find Object Results window is fixed
  • NullReferenceException on deleting a table from the diagram in Query Builder is fixed
  • ArgumentException on drag'n'dropping a schema to a Database Diagram document is fixed
  • NullReferenceException on clicking a procedure and entering a space is fixed
  • The error on killing a session during compilation of dependent objects is fixed
  • ArgumentException on creating a database project with importing schema objects of Oracle 11 is fixed
  • NullReferenceException on trying to edit invalid query from Data Source window is fixed
  • OutOfMemoryException on editing data of a CLOB field in Data Editor is fixed
  • InvalidOperationException on editing data in Data Editor is fixed
  • ORA-01801 on getting materialized view logs in Database Explorer is fixed
  • InvalidOperationException on editing a column in Database Diagram is fixed

New in dbForge Studio for Oracle 3.0.87 (Aug 26, 2011)

  • NullReferenceException on deleting a table from the design view in Query Builder is fixed
  • The error on saving a package body is fixed
  • NullReferenceException on trying to switch on the "Show navigation bar" option is fixed
  • Many improvements are made in the Code Completion feature and around it
  • Several minor fixes are made in object editors, Query Builder and SQL document functionalities
  • A couple of errors is fixed in Data and Schema Comparers

New in dbForge Studio for Oracle 3.0.82 (Aug 18, 2011)

  • Major New Features:
  • Schema Comparison Tool:
  • Being first released as a separate tool, dbForge Schema Compare for Oracle was integrated into dbForge Studio to provide even greater schema change management capabilities. It is a comprehensive tool for database schema comparison and synchronization that can be used both by application developers and database administrators (DBAs). This tool can become a great assistant when you need to identify the impact of changes made to your database schema, as it easily points out all differences and allows generating customized Oracle schema synchronization script.
  • Data Comparison Tool:
  • Being first released as a separate tool, dbForge Data Compare for Oracle was integrated into dbForge Studio to provide smooth integration with the rest of functionality. It is a powerful, fast, and easy-to-use tool for Oracle table data comparison and synchronization. It helps you quickly compare data in tables, find the differences at a glance, and generate a script to effortlessly synchronize data.
  • New Query Builder:
  • Query Builder was completely re-designed to meet user needs. Now it allows you to build any complex queries visually. You can create sub-queries, add tables, create joins, or edit conditions with several clicks of the mouse. Following are the new features:
  • The state-of-art diagram with zooming and keyboard support
  • Preview and printing of the diagram
  • Visual addition of sub-queries to any part of the main query
  • Query outline (Document Outline window)
  • Visual editing of sub-queries
  • Expression builder for creating complex conditions
  • Copy/Paste for tables on the diagram
  • Undo/Redo support
  • Greatly Enhanced Data Editor:
  • Over 50 new features and usability improvements were made to Data Editor to provide maximum freedom when working with data. Here are some of them:
  • Quick filtering feature is added
  • Foreign Key lookup editor is added
  • Server-side sorting and filtering is implemented to avoid retrieving all data from the table and enhance work in Paginal Mode
  • Few indications are added to inform user about Data Editor's state
  • Editing of tables in join statements is enabled now
  • Option for numbering records is added
  • Copying data to clipboard with header is added
  • Integration with charts, data reports, and pivot table component
  • Powerful Data Export and Import:
  • With Data Export and Import tools, you can export data from tables or views of your Oracle database, and after that you will be able to insert the exported data into the table you need. Data Export and Data Import provide the following features:
  • Easy-to use Data Export Wizard for exporting data to HTML, MS Excel, RTF, XML, ODBC, Text, MS Access, PDF, CSV, and DBF formats.
  • Highly customizable Data Import Wizard for exporting data from CVS, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML formats.
  • Ability to export data from several tables at once
  • Possibility to export and import data from command line
  • Master-Detail browser:
  • Explore and analyze master-detail data in a convenient browser with the following features:
  • Design view allows building relations between tables with setting where condition and fetch limit, choosing fields for output, and sorting them by default
  • Data of the parent table/view is shown in the upper part of the Data view to allow analyzing data of child tables/views without extra navigation.
  • The document allows saving and loading data and diagram for future use
  • Sorting and filtering data in the Data view
  • Ability to analyze self-referencing tables
  • Data Reports:
  • Every user can benefit from a modern way of generating reports. Less time and manual work is required to gett required data from a database, analyze, and print it as a smart, clear, and stylish report tuned for each particular case.
  • Pivot Table:
  • Users can convert large amounts of data into compact and informative summaries - pivot tables. They can rearrange any obscure data by a simple drag of a mouse to get the layout that is best for understanding data relations and dependencies.
  • Redesigned Schema Export Wizard:
  • Schema Export wizard has been totally redesigned to provide more freedom for exporting schemas. It features the following:
  • Capability to save export options for future use
  • Support of command line interface
  • Automatic archiving of schema backup scripts
  • Writing a report about export process into a log file
  • Automatic removing old backup files based on date or quantity
  • Object Viewer - a simple way to view object's details:
  • Object Viewer provides an easy way for analyzing objects and their structure right from Database Explorer. It offers:
  • Three views to display properties, DDL (text), and data of the selected object
  • Inner navigation through object hierarchy
  • History with previously viewed objects
  • Extended information about each object in the Properties view
  • Minor New Features
  • Quick generation of template SQL scripts for database objects:
  • Thanks to this new functionality, you can save your time while working with database objects. For example, you can quickly generate template CREATE, DROP, DROP and CREATE, SELECT, INSERT, UPDATE, or DELETE scripts for tables. This option is available in the context menu and called ‘Generate Script As’.
  • Reworked Query Profiler:
  • Query Profiler tool was reworked for more convenient usage and extended with session statistics:
  • Query plan is displayed in tree-list control in order to show execution step properties
  • Session statistics changes are captured to reflect query impact
  • Profiling history that can be saved for further analysis
  • Compare statistics results with differences highlight
  • Profiling results printing
  • Wizard for execution of large SQL scripts:
  • The new version provides a special Execute Script Wizard to enable quick and convenient execution of large SQL scripts without waiting for their opening in the editor. It takes only to select a script and enjoy the executed result.
  • Code Snippets Manager:
  • Code Templates features is now renamed to Code Snippets and extended with the manager window for adding and editing SQL templates.
  • Import and Export Settings Wizard:
  • Import and Export Settings Wizard allows you to export and import all your settings, layout, toolbars, keyboard shortcuts. Wizard also allows you to reset settings to their default values. You may export, import, and reset settings completely or partially.
  • Brand new start page:
  • New functional start page providing the easiest way to learn the product's features and to run the most frequently used ones added.
  • New state-of-the-art skins:
  • Four new UI skins are added to improve the application appearance.
  • Improvements:
  • SQL intellisense functionality improved:
  • SQL intellisense functionality is improved to make coding easier. Extended code completion, quick object information, code snippets will simplify your work.
  • Improved Security Manager:
  • Ability to edit permissions for several users is added
  • Editing users and working with Security Manager window is simplified
  • Database Projects Improved:
  • Building project to a single script
  • Building project to a collection of scripts
  • Multiple build configurations
  • Easy object deleting from project
  • Search and Replace Extended:
  • The following search and replace functionality is added:
  • Search in data
  • Search in LOB Viewer/Editor
  • Search and replace in project files
  • Search and replace in files on disc
  • Filter toolbar in the Error List window:
  • Filter toolbar is added to Error List window to show the quantity of errors, warnings, and messages. Also it filters the list of records, so that you can access the records of the selected type in one click.

New in dbForge Studio for Oracle 2.55.149 (Jun 12, 2009)

  • ArgumentException on creating a new query builder document was fixed