What's new in dbForge Schema Compare for Oracle 4.5.226
Feb 19, 2024
- User-reported bug fixes:
- Enhanced the comparison algorithm for Access parameters in External tables, which previously could result in false differences (D136202)
- Fixed an error that occurred when synchronizing indexes (D139792)
New in dbForge Schema Compare for Oracle 4.5.102 (Jul 22, 2023)
- 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
New in dbForge Schema Compare for Oracle 4.5.17 (Mar 16, 2023)
- 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 (D110184)
- Fixed an error that occurred when generating a script for columns with DEFAULT ON NULL (D100987)
- Resolved an issue with manual product activation (D107637)
- Improved the error diagnostics (D98041)
- 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
New in dbForge Schema Compare for Oracle 4.4.26 (Jul 19, 2022)
- 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.
New in dbForge Schema Compare for Oracle 4.4.25 (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 (D80591)
New in dbForge Schema Compare for Oracle 4.4.20 (May 23, 2022)
- Several minor user-reported bugs are fixed
New in dbForge Schema Compare for Oracle 4.4.19 (Mar 28, 2022)
- 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
New in dbForge Schema Compare for Oracle 4.4.17 (Feb 4, 2022)
- 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
New in dbForge Schema Compare for Oracle 4.4.9 (Jan 13, 2022)
- 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
New in dbForge Schema Compare for Oracle 4.3.19 (Oct 27, 2021)
- Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns (Z67520)
New in dbForge Schema Compare for Oracle 4.3.15 (Jul 16, 2021)
- Fixed processing of differences in NOT NULL values for the PRIMARY KEY columns.
- Other minor user-reported bugs are fixed.
New in dbForge Schema Compare for Oracle 4.3.11 (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
New in dbForge Schema Compare for Oracle 4.2.18 (Sep 29, 2020)
- 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)
New in dbForge Schema Compare for Oracle 4.2.12 (Jul 3, 2020)
- Connectivity support for Oracle 20c is implemented
New in dbForge Schema Compare for Oracle 4.1.28 (Dec 23, 2019)
- User reported bug fixes:
- Problem with generating sql script with table virtual column is fixed (T280712 )
- Other minor user reported bugs are fixed
New in dbForge Schema Compare for Oracle 4.1.23 (May 8, 2019)
- Problem with lost synchronization script is fixed (ORCL-2075)
- Problem with foreign keys comparing is fixed (T282207)
- Other minor user reported bugs are fixed
New in dbForge Schema Compare for Oracle 4.1.18 (Apr 16, 2019)
- 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
New in dbForge Schema Compare for Oracle 4.0.88 (Dec 29, 2018)
- 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
New in dbForge Schema Compare for Oracle 4.0.82 (Nov 19, 2018)
- Problem with activation is fixed
New in dbForge Schema Compare for Oracle 4.0.79 (Nov 14, 2018)
- Problems with connection to Oracle 12.1.0.1 are fixed
New in dbForge Schema Compare for Oracle 4.0.75 (Oct 30, 2018)
- Problems with special system table for full text search index are fixed (T243422, T243929)
- Other user reported bugs are fixed
New in dbForge Schema Compare for Oracle 4.0.43 (Sep 26, 2018)
- User reported bug fixes:
- Table rebuild issue is fixed (T243929)
- Problems with database objects describing are fixed (T265092,T264461,264619)
New in dbForge Schema Compare for Oracle 4.0.8 (Aug 21, 2018)
- 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
- Imporoved 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)
New in dbForge Schema Compare for Oracle 3.0.29 (Apr 25, 2017)
- dbForge Schema Compare for Oracle Supports Connection to Oracle Database 12c Release 2
New in dbForge Schema Compare for Oracle 3.0.27 (Dec 27, 2016)
- Greatly improved suggestion performance
- Improved XML View and new JSON View for Data Editor and Viewer Window
- Styled icons are used by default
- Data type information to the column header in Data Grid added
- Bugs fixed
New in dbForge Schema Compare for Oracle 3.0.17 (Oct 19, 2016)
- 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
New in dbForge Schema Compare for Oracle 2.7.143 (Feb 3, 2015)
- 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
New in dbForge Schema Compare for Oracle 2.6.140 (Aug 1, 2014)
- 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
New in dbForge Schema Compare for Oracle 2.5.119 (Dec 5, 2013)
- 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)
New in dbForge Schema Compare for Oracle 2.5.98 (Oct 18, 2013)
- 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
New in dbForge Schema Compare for Oracle 2.0.192 (Aug 14, 2013)
- InvalidOperationException on working with SQL document in Express edition is fixed (T75878)
- NullReferenceException on creating snapshot via command line is fixed (T74698)
New in dbForge Schema Compare for Oracle 2.0.184 (Aug 12, 2013)
- 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)
New in dbForge Schema Compare for Oracle 2.0.180 (Jun 20, 2013)
- The problem with TFS in Schema Compare is fixed (T70020)
New in dbForge Schema Compare for Oracle 2.0.170 (Apr 9, 2013)
- 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)
New in dbForge Schema Compare for Oracle 2.0.161 (Jan 12, 2013)
- 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)
New in dbForge Schema Compare for Oracle 2.0.153 (Dec 3, 2012)
- 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)
New in dbForge Schema Compare for Oracle 2.0.129 (Jul 27, 2012)
- Problem with new schema comparison window is fixed (T41812)
New in dbForge Schema Compare for Oracle 2.0.116 (Jun 21, 2012)
- Error Report on dragging a document is fixed (T40368)
New in dbForge Schema Compare for Oracle 2.0.108 (May 24, 2012)
- Schema synchronization scripts for Logging and Compress table options is fixed
- Error report during SQL script execution is fixed
- Problem with disabled Data Editor is fixed
- Problem with paramater parsing in SQL document is fixed
New in dbForge Schema Compare for Oracle 2.0.106 (May 7, 2012)
- New Features:
- Report generation options were added to Command line
- User reported bug fixes:
- OutOfMemoryException on comparing big schemas is fixed
- Problem with constraints describe on Oracle 7 is fixed
New in dbForge Schema Compare for Oracle 2.0.101 (May 7, 2012)
- User reported bug fixes:
- Issue when Error List isn't cleared on executing query with errors is fixed
- The problem with setting a filter for large fields in Data Editor is fixed
- Problem with hiding the "Loading Data" label is fixed
- OutOfMemoryException on toggling bookmarks in SQL document is fixed
- Incorrect behaviour with displaying bookmarks on editing text in SQL document is fixed
- Incorrect search of text occurrence in SQL Document is fixed
- NullReferenceException on executing a statement in SQL Document is fixed
- NullReferenceException on editing data in Date columns in Data Editor is fixed
- Few problems with showing differences in Schema Compare document are fixed
- ArgumentNullException on comparing schemas on a single connection is fixed
- NullReferenceException on closing Schema Compare wizard is fixed
- Problems with showing differences in Schema Compare document are fixed
- InvalidCastException on editing DATE fields in Data Editor is fixed
- NullReferenceException on comparing XML schemas is fixed
- Schema synchronization scripts are generated correctly now
- Wrong behaviour with unstable network in Data Editor is fixed
- Incorrect comparing of index properties is fixed
- Incorrect generation of records in log file during schema comparing is fixed
- Path for comparison report is saved now
New in dbForge Schema Compare for Oracle 2.0.86 (Dec 13, 2011)
- IndexOutOfRangeException on comparing schemas is fixed
- Determining CHAR and VARCHAR2 size is fixed
- Freezing on data comparison is fixed
- 'Out of memory' error on x64 systems is fixed
- An error on *.scomp loading is fixed
- Incorrect identification of mapped objects in *.dcomp is fixed
- Incorrect navigation on the mapping page is fixed
New in dbForge Schema Compare for Oracle 2.0.85 (Dec 8, 2011)
- Invalid data type for virtual columns is fixed
- Index was out of range is fixed
- Incorrect behavior with circular reference in schema is fixed
- Incorrect SOURCE-object processing is fixed
New in dbForge Schema Compare for Oracle 2.0.80 (Oct 7, 2011)
- Semicolon duplication error in the end of Source Objects
New in dbForge Schema Compare for Oracle 2.0.77 (Aug 18, 2011)
- Problems with trial checking are fixed
New in dbForge Schema Compare for Oracle 2.0.73 (Aug 18, 2011)
- 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
New in dbForge Schema Compare for Oracle 2.0.71 (Jul 29, 2011)
- Incorrect working with virtual columns is fixed
- Incorrect working with comment objects is fixed
- Exception in Standard edition during comparison is fixed
- Problem with displaying system indexes for nested tables is fixed
New in dbForge Schema Compare for Oracle 2.0.62 (Jun 16, 2011)
- Schema snapshots and version control integration:
- The new version allows you to create schema snapshots, that are frequently used for audit and roll-back purposes, and automatically commit them to version control system, compare previous versions of schema with the current one (source control integration).
- This functionality is extremely useful, as it provides a simple approach to significantly reduce time and effort needed for analyzing changes available in different database versions.
- Command line support:
- Use command line to automate routine synchronizations. Now such tasks can be accomplished in the automatic unattended mode. This functionality allows one to use our tool for setting up continuous integration.
- Comparison and synchronization of wrapped and unwrapped objects:
- With the help of this functionality, you can compare wrapped and unwrapped PL/SQL objects. This will allow you to detect changes in the production database, where objects are wrapped.
- Extended support of schema objects:
- The new version supports clusters, object permissions, and java-source objects.
- Compatibility:
- Support for Oracle 11 R2 Express Edition
- Other improvements:
- PURGE RECYCLEBIN option in Synchronization Wizard is added
- Possibility to ignore comments in the text-comparer control is added
- Start page is improved
- Four state-of-the-art skins are added
- Possibility to open connections in New Schema Comparison Wizard asynchronously is added
- The SYSDBA role is chosen automatically when the sys name is typed in the Database Connection Properties dialog box