dbForge Schema Compare for Oracle Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

  • Fixed an issue that caused a cyclic dependency error(#241583)
  • Improved metadata processing for specific cultures
  • Resolved clipboard data corruption when copying HTML data with duplicate column names
  • Fixed the Object Filter functionality in schema comparison console mode

2026.1.39 15-May-2026

User-reported bug fixes

  • Several minor bugs are fixed

2026.1.31 11-May-2026

Schema Compare

  • Added the Discard Changes option to the Objects Filter toolbar

AI Assistant

  • Improved AI Assistant by adding support for database index metadata

Text Editor

  • Added the Enclose identifiers in quotes feature to the SQL Editor
  • Added index name suggestions in code completion
  • Added indexed column icons in Quick Info

Improvements

  • Added the ability to pin document tabs
  • Added the ability to restore document tab order

User-reported bug fixes

  • Fixed the behavior of the "SQL Look In" option in the Find and Replace control
  • Improved saving of window layouts and restoration of window positions after restarting the Studio
  • Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
  • Updated the installation wizard to not display the "Successful Install" page during dbForge product updates

2025.3.149 25-Mar-26

User-reported bug fixes

  • Fixed the display of row-level differences in schema comparison results

2025.3.107 12-Feb-26

User-reported bug fixes

  • Several minor bugs are fixed

2025.3.93 29-Jan-26

User-reported bug fixes

  • Fixed an Error Report issue that occurred when working with the Schema Export wizard

2025.3.61 24-Dec-25

Connectivity

  • Added support for Oracle AI Database 26ai

Text Editor Improvements

  • Added scroll bar annotations
  • Added an option to automatically surround selections
  • Added camelCase formatting for identifiers
  • Expanded syntax check for LIST_OBJECTS function calls

User-reported bug fixes

  • Improved Schema Comparer so that, when Ignore White Spaces is enabled, it ignores spaces and line breaks in all comment types (single-line, block, and multi-line block) for source-code objects (#164754)
  • Implemented a text preview for CLOB data types instead of an icon
  • Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

  • Re-enabled the option to select the OUT modifier for parameters in dynamic SQL, which was mistakenly disabled

      • 2025.2.109 31-Oct-25

      User-reported bug fixes

      • Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

      2025.2.91 23-Oct-25

      User-reported bug fixes

      • Several minor bugs are fixed

      2025.2.37 23-Sep-25

      AI Assistant

      • Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
      • Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog

      Improvements

      • Improved encryption capabilities
      • Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
      • Introduced the ability to customize the position where new document tabs open
      • Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
      • Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values
      • Added support for JSON data type modifiers

      User-reported bug fixes

      • Fixed an issue with schema comparison(#216476)
      • Resolved an issue where the Data Viewer content was lost when switching focus between tool windows

      2025.1.230 21-Aug-25

      User-reported bug fixes

      • Fixed an issue that occurred when closing an application

      2025.1.186 21-Jul-25

      User-reported bug fixes

      • Fixed an issue that occurred due to inconsistent check constraint metadata (#208437)
      • Fixed an error in Schema Compare when using the Ignore column order in indexes option
      • Removed opening the connection on the main thread when opening the parameter input form
      • Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned
      • Fixed an issue with long file names

      2025.1.134 23-Jun-25

      User-reported bug fixes

      • Several minor user-reported bugs are fixed

      2025.1.124 16-Jun-25

      AI Assistant is added

      • Context-aware query generation
      • Conversion of natural language to SQL
      • Query optimization
      • SQL explanations
      • SQL troubleshooting
      • Error analysis and recommendations
      • AI chat
      • Integration with the dbForge tools

      Improvements

      • Updated color palettes for the Light and Dark skins
      • Refined font rendering and the coloring of syntax errors
      • Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

      User-reported bug fixes

      • Several minor user-reported bugs are fixed

      6.0.85 13-Mar-25

      Improvements

      • Added Show Ignored Differences, which can be turned on on the General page of the Options > Schema Comparison window
      • Added Save Command Line to the Comparison Report wizard
      • Added a visual Object Filter
      • Added support for filtering objects from the command line
      • Added Alt+Down Arrow to navigate to the subsequent difference

      Data Editor

      • Replaced the Custom AutoFilter window with the advanced Filter Editor window
      • Added a new command to the shortcut menu - Set Value To > Unique Identifier

      Query history

      • Redesigned Query History with a new toolbar featuring an improved range selection and the Clear option for deleting query history

      User-reported and internal bug fixes

      • Added support for the JSON_storage_clause syntax and the following keywords: NOSCALE, NOKEEP, JSON_SERIALIZE, MAXTRANS, COMPUTE STATISTICS, and CELL_FLASH_CACHE (#182388)
      • Implemented processing for a cyclic dependency case involving identical object names in the source and target (#145053)
      • Improved parser error messages by including a code fragment in the error text (#182388)
      • Resolved an issue with connecting to a server running version 19.24 (#172143, #179239)
      • Added support for GRANT statements across multiple schemas (p208934)
      • Fixed a data retrieval issue in Paginal mode when the result set includes unnamed columns
      • Enhanced data filtering capabilities in Data Editor through the integration of a new Filter Editor
      • Fixed the design of application settings pages in the Options window to ensure proper scaling across different DPI settings
      • Resolved an issue causing the truncation of milliseconds in TIMESTAMP(6) WITH TIME ZONE values

      4.5.237 09-Jul-24

      User-reported and internal bug fixes

      • Fixed the error that occurred when saving data to the clipboard (Ctrl+C) in the Data Editor

      4.5.236 21-Jun-24

      • Fixed the behavior of reading and comparing table column comments (#135330)
      • Resolved an issue with displaying schema object differences for large source objects (#153716)

      4.5.226 19-Feb-24

      User-reported bug fixes

      • Enhanced the comparison algorithm for Access parameters in External tables, which previously could result in false differences (#136202)
      • Fixed an error that occurred when synchronizing indexes (#139792)

      4.5.102 21-Jul-23

      Improvements

      • Added connectivity support for Oracle 23c

      User-reported and internal bug fixes

      • Fixed the loss of TABLESPACE and STORAGE OPTIONS during the synchronization of tables, indexes, and materialized views

      4.5.17 16-Mar-23

      New features and improvements

      • Added support for Linux and macOS via CrossOver
      • Improved the behavior of table columns reordering

      User-reported bug fixes

      • Fixed an error that occurred when attempting to save a schema comparison project with a name that exceeds system limits (#110184)
      • Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL (#100987)
      • Resolved an issue with manual product activation (#107637)
      • Improved the error diagnostics (#98041)
      • Resolved an issue with the synchronization between a column and a sequence
      • Fixed a bug causing the application to crash upon launch
      • Improved memory handling when viewing large sets of data in the Paginal Mode of the Data Editor
      • Improved the generation of the PCTFREE property synchronization script
      • Fixed the highlighting of built-in functions
      • Fixed a bug that occurred when describing partitions
      • Fixed a bug that occurred when generating DDL triggers

      4.4.26 19-Jul-22

      User-reported 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 (#80591)

      4.4.20 23-May-22

      User-reported bug fixes

      • Several minor user-reported bugs are fixed

      4.4.19 28-Mar-22

      User-reported bug fixes

      • Fixed an issue that blocked the program from being installed on specific environments due to the shell folder constant expansion failure
      • 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
      • Resolved an issue that caused the program license reactivation process after the BIOS update to fail

      4.4.17 04-Feb-22

      User-reported bug fixes

      • Fixed the behavior of the application installer when checking the version of the .NET Framework
      • Fixed an unexpected exception that occurred when closing a document that was modified in an external editor
      • Other minor user-reported bugs are fixed

      4.4.9 13-Jan-22

      New features and improvements

      • Added connectivity support for Oracle 21c
      • Added a new schema comparison option Ignore MAXVALUE
      • Added a new schema comparison option Ignore INCREMENT BY
      • Added a new schema comparison option Ignore CACHE
      • Added a new schema comparison option Ignore CYCLE
      • Drastically improved schema comparison reports
      • Improved the behavior of the Ignore START WITH schema comparison option

      4.3.19 27-Oct-21

      User-reported bug fixes

      • Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns (#67520)

      4.3.15 16-Jul-21

      New features and improvements

      • Added ability to save * .dcomp and * .scomp files in the Comparison Wizard before running the comparison
      • Added ability to treat execution errors as warnings during schema synchronization

      User-reported bug fixes

      • Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns
      • Other minor user-reported bugs are fixed

      4.3.11 26-Jan-21

      New features and improvements

      • Activation of the tool via the command-line interface
      • Improved working with virtual columns when comparing and synchronizing schemas

      4.2.18 29-Sep-20

      User-reported bug fixes

      • 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)

      4.2.12 02-Jul-20

      New features and improvements

      • Connectivity support for Oracle 20c is implemented

      4.1.28 23-Dec-19

      User-reported bug fixes

      • Problem with generating sql script with table virtual column is fixed (T280712)
      • Other minor user-reported bugs are fixed

      4.1.23 08-May-19

      User-reported bug fixes

      • Problem with lost synchronization script is fixed (ORCL-2075)
      • Problem with foreign keys comparing is fixed (T282207)
      • Other minor user-reported bugs are fixed

      4.1.18 16-Apr-19

      New features and improvements

      • Brand New Application Skins
      • Support for Oracle 19c
      • AutoCommit Mode ON/OFF

      User-reported bug fixes

      • Problem with default value and collation is fixed (T276888)
      • Problem with Generate Fully Qualified Object Name option is fixed (ORCL-1710)
      • Problem with incorrect temporal table name is fixed (ORCL-1920)
      • Other minor user-reported bugs are fixed

      4.0.88 29-Dec-18

      User-reported bugs fixed

      • Problem with option "Generate fully qualified object names" is fixed
      • Incorrect description of system properties is fixed
      • Materialized view creation issue is fixed
      • Other user-reported bugs are fixed

      4.0.82 19-Nov-18

      User-reported bugs fixed

      • Problem with activation is fixed

      4.0.79 14-Nov-18

      User-reported bugs fixed

      • Problems with connection to Oracle 12.1.0.1 are fixed

      4.0.75 30-Oct-18

      User-reported bugs fixed

      • Problems with special system table for full text search index are fixed (T243422, T243929)
      • Other user-reported bugs are fixed

      4.0.43 25-Sep-18

      User-reported bug fixes

      • Table rebuild issue is fixed (T243929)
      • Problems with database objects describing are fixed (T265092,T264461,264619)

      4.0.8 21-Aug-18

      Support for new server

      • Oracle Database 18c connectivity support
      • Support for Oracle 12c objects

      Schema comparison options

      • Associate column names having similar name options
      • Disable dependency analysis
      • Ignore case in objects names
      • Ignore character length semantics
      • Ignore check constraints
      • Ignore collations
      • Ignore datatypes in column
      • Ignore Dependent Objects In Other Schemas
      • Ignore External Table Location Information
      • Ignore firing order for triggers
      • Ignore Flashback Archive
      • Ignore foreign keys actions ON UPDATE and ON DELETE
      • Ignore indexes
      • Ignore indexes' names
      • Ignore indexes present only in Target
      • Ignore INSTEAD OF Triggers
      • Ignore materialized view START WITH value
      • Ignore Parallel
      • Ignore primary keys
      • Ignore sequence MinValue
      • Ignore sequence START WITH value
      • Ignore spaces in objects names
      • Ignore Supplemental Log
      • Ignore Table DML Triggers
      • Ignore uniques

      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

      Other Improvements

      • Support for TEMPORARY TABLE
      • Expanded Comparison Reports functionality
      • Automatic selection of comparison key for object without equal unique indexes
      • Improved visual style of tool
      • Command line execution file wizard
      • Trial product activation
      • Support for PowerShell
      • Specific exit codes added
      • FIPS compliance

      User-reported bug fixes

      • Automatic partitioning issue is fixed (T260470)
      • NullReferenceException issues are fixed (T259281, T262877)
      • Table rebuild issue is fixed (T243929)
      • Problem with "Save as my defaults" is fixed (T252343)
      • Table renaming issues are fixed (T243422, T243929)
      • Other user-reported bugs are fixed (T249138, T210706, T210706, T202941, T31026)

      3.0.29 24-Apr-17

      • Oracle Database 12c Release 2 connectivity support

      3.0.27 01-Nov-16

      • Greatly improved suggestion performance
      • Improved XML View and new JSON View for Data Editor and Viewer Window
      • Styled icons are used by default
      • Bugs fixed

      3.0.17 10-Feb-16

      • Schema Comparison UI significantly redesigned
      • Support of complete range of TFS version control system from 2005 to 2015
      • Support connection to Oracle server via IPv6
      • Redesigned installation wizard

      2.7.144 02-Feb-15

      SQL Editing and Execution

      • Query execution pane
      • Command-line interface for SQL formatting
      • Option to set files encoding within the /execute command-line operation

      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

      • Create Schema Snapshot wizard window is modeless
      • Enhanced Find and Replace window
      • On-line documentation

      2.6.140 31-Jul-14

      Database Connectivity

      • Connection via Windows authentication is added
      • Windows connection coloring is added

      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 Editor and Viewer

      • Ability to view results as a structured XML file is added

      User Interface

      • Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
      • Restoring document tabs from the last session is possible now
      • Switching between wizard window and primary window is possible now

      2.5.119 04-Dec-13

      • InvalidOperationException while editing query results is fixed (T89648)
      • IndexOutOfRangeException while connecting to Oracle 8.0.x is fixed (T88617)
      • Incorrect behaviour while setting custom keyboard shortcut for a command is fixed (T89000)

      2.5.98 17-Oct-13

      Oracle 12c is supported

      New features of SQL Editor

      • Code completion is added
      • SQL Code Formatter is added

      Minor features

      • Database objects are described faster now
      • 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
      • Microsoft Windows 8.1 is supported

      2.0.192 14-Aug-13

      • InvalidOperationException on working with SQL document in Express edition is fixed (T75878)
      • NullReferenceException on creating snapshot via command line is fixed (T74698)

      2.0.184 11-Jul-13

      • NullReferenceException on working with an SQL document is fixed (T73600)
      • An error while comparing a schema in Direct Mode is fixed (R18057)
      • NullReferenceException on viewing unrepresentable data in the Data Editor is fixed (R22735)

      2.0.180 18-Jun-13

      • The problem with TFS in Schema Compare is fixed (T70020)

      2.0.170 10-Apr-13

      • NullReferenceException on changing a date field in Data Editor is fixed (R17000)
      • Incorrect behaviour with inserting the Now value into the Timestamp field in Data Editor is fixed (R16260)
      • The problem with punctuation's visibility in code editor with black background being set is fixed (T64968)
      • Incorrect behaviour with editing selected text in code editor is fixed (R16116)

      2.0.161 11-Jan-13

      • On opening Connection the ORA-00933 error is received (R14892)
      • Error on displaying connection editor form is fixed (T16315)
      • The Error on clicking MyDefaults in Schema Synchronization Wizard is fixed (R15446)
      • 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)
      • 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)

      2.0.153 19-Nov-12

      • Problem with hidden buttons in the Schema Comparison wizard is fixed (T14812)
      • Problem with launching the application through the command line via MSBuild is fixed (T41884, T40920)
      • ExternalException in GDI+ on typing text in SQL document is fixed (T42514)
      • Incorrect behaviour with removing the selected text in SQL document on closing the Edit Parameters dialog is fixed (T59896)
      • InvalidCastException on filtering data in Data Editor is fixed (T59944)
      • Incorrect determining of the DBA role for connected user is fixed (R14654)
      • Incorrect behaviour with cycled dependencies between object and table types during schema comparison is fixed (T59430)
      • Problem with updating data in a view with INSTEAD OF trigger on it is fixed (T60936)

      2.0.128 25-Jul-12

      • Problem with new schema comparison window is fixed (T41812)

      2.0.116 20-June-12

      • Error Report on dragging a document is fixed (T40368)

      2.0.108 14-May-12

      User-reported bug fixes

      • Schema synchronization scripts for Logging and Compress table options is fixed (T37909)
      • Error report during SQL script execution is fixed (R9055)
      • Problem with disabled Data Editor is fixed (R9075)
      • Problem with parameter parsing in SQL document is fixed (R7852)

      2.0.106 23-Apr-12

      New Features

      • Report generation options were added to Command line (T34566)

      User-reported bug fixes

      • OutOfMemoryException on comparing big schemas is fixed (T38607)
      • Problem with constraints describe on Oracle 7 is fixed (T37308)

      2.0.101 23-Mar-12

      User-reported bug fixes

      • Issue when Error List isn't cleared on executing query with errors is fixed (R5686)
      • The problem with setting a filter for large fields in Data Editor is fixed (T35222, T35564)
      • Problem with hiding the "Loading Data" label is fixed (R6275)
      • 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)
      • NullReferenceException on executing a statement in SQL Document is fixed (R7601)
      • NullReferenceException on editing data in Date columns in Data Editor is fixed (T36314)
      • Few problems with showing differences in Schema Compare document are fixed (T31850)
      • ArgumentNullException on comparing schemas on a single connection is fixed (R6134)
      • NullReferenceException on closing Schema Compare wizard is fixed (R7095)
      • Problems with showing differences in Schema Compare document are fixed (T31850)
      • InvalidCastException on editing DATE fields in Data Editor is fixed (R7325)
      • NullReferenceException on comparing XML schemas is fixed (R7175)
      • Schema synchronization scripts are generated correctly now (T37909)
      • 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)

      2.0.86 07-Dec-11

      User-reported bug fixes

      • IndexOutOfRangeException on comparing schemas is fixed (T33255, T33283)
      • Determining CHAR and VARCHAR2 size is fixed (T32819)
      • Freezing on data comparison is fixed (T31698)
      • 'Out of memory' error on x64 systems is fixed (T31317, T31735, T32846, T31917, R3870)
      • An error on *.scomp loading is fixed (R3742)
      • Incorrect identification of mapped objects in *.dcomp is fixed (R3739)
      • Incorrect navigation on the mapping page is fixed (R3737)

      2.0.85 31-Oct-11

      User-reported bug fixes

      • Invalid data type for virtual columns is fixed (T33244)
      • Index was out of range is fixed (T33255, T33283)
      • Incorrect behavior with circular reference in schema is fixed (T32784)
      • Incorrect SOURCE-object processing is fixed (T32728)

      2.0.80 19-Sep-11

      User-reported bug fixes

      • Semicolon duplication error in the end of Source Objects (T31635)

      2.0.77 15-Aug-11

      User-reported bug fixes

      • Problems with trial checking are fixed

      2.0.73 29-Jul-11

      User-reported bug fixes

      • Possibility to exclude objects that are in the bin from comparison is added
      • Out of memory exception is fixed
      • Combobox for selecting databases was removed from the SQL toolbar

      2.0.71 1-Jul-11

      User-reported bug fixes

      • Incorrect working with virtual columns is fixed
      • Incorrect working with comment objects is fixed
      • Exception in Standard edition during comparison is fixed (T29721, T30350)
      • Problem with displaying system indexes for nested tables is fixed

      2.0.62 06-Jun-11

      User-reported bug fixes

      • Incorrect working with indexes in DBA mode is fixed

      2.0.59 02-Jun-11

      New Features

      • Database comparison and synchronization via command line
      • Capability to create schema snapshots and compare them with each other or with a database
      • Version control system integration for database change tracking
      • Synchronization of object permissions
      • Support for cluster tables and Java Source objects
      • Comparison and synchronization of wrapped objects
      • New comparison options: Ignore Permissions, Compare Wrapped vs Unwrapped PL/SQL Objects
      • New synchronization options: Purge Recycle Bin
      • Start page improvement
      • Support for Oracle 11 R2 Express Edition

      User-reported bug fixes

      • Incorrect synchronization of COMMENT OBJECT is fixed (T28059)
      • Incorrect working with triggers is fixed
      • Working with server that is turned off is fixed (T27463)
      • System.InvalidCastException during comparison process is fixed (T27849)
      • Exception on external editing of *.scomp file is fixed (T28059)
      • Examples on command line usage are added to documentation (T28207)

      1.00.183 23-Feb-11

      • First release of dbForge Schema Compare for Oracle