Features

• Compatibility with Schema Compare/Data Compare for Oracle 5.7.29.2617.

Features

• Compatibility with Schema Compare/Data Compare for Oracle 5.7.28.2494.

Fixes

• Fixed issue where database user password change would cause an exception.
• Comments on Invisible columns are now supported correctly by Oracle 19, so are read from scripts folders again if the folder is marked as a v19 one.

Features

• Upgraded Devart.Data.Oracle to v9.14.1353.

Fixes

• Fixed issue where having "data" directory with a file in it, in root directory of the project, would cause "Object reference not set to an instance of an object" error during refresh.
• Fixed parsing column returning json value of type DATE.

Fixes

• Fixed issue where static data difference was not visible after changing column type.

Features

• Added COLLATION keyword support for columns.

Fixes

• Static data BinaryDouble issue.

Fixes

• ComparisonOptions.xml files containing the old IncludeStorageTablespaceAndPartitioning option will now be correctly read as having both IncludeStorageTablespace and IncludeStoragePartitioning set.

Fixes

• Truncating text in repeat_inteval property in job objects has been fixed.
• Fixed trigger difference detection in base object name.
• Fixed detecting difference in objects with unknown characters.
• Fixing parser problem with building dates inside functions.

Features

• Added support for the UNDER keyword for views.

Fixes

• Fixed an issue where using some of the Control Characters in Table Column's Comment would cause the object to indefinitely appear as a difference.

Fixes

• Fixed the inability to scroll larger objects.
• Fixed issue preventing users from opening Settings more then once.
• Fix for remove SET DEFINE OFF clause from object scripter when an object is deleted.
• Fixed issue preventing some characters from being removed when parsing PL/SQL code.
• Fixed issue preventing users from displaying: Difference calculation failed when committing part of objects.

Features

• Upgraded Devart Oracle database connector library (9.13.1127).
• Separated Tablespace and Partitioning options into two independent options.
• Added support for multi-select when resolving conflicts.
• Added support for Job definitions.

Fixes

• Fixed generating rebuild index action.
• Fixed issue where Source Control could crash when installed on a clean machine.

Features

• Added optional vertical scrollbar for projects with a large number of schemes.

Fixes

• Fixed support for lower-case usernames.
• Fixed error about object referencing a nonexistent instance during index conflicts.
• Removed Features Flags for QueueTable and Queue objects.

Features

• Added the ability to select multiple schemas when creating a new project.
• Added support for PLSQL_CCFLAGS.
• Added support for connect via proxy users.

Fixes

• Fixed parsing error about TRUNC(SYSDATE).
• Fixed sorting for Locked By columns.
• Improved the "wrap statements with existence checks" option so that it can be dropped materialized view before creating the new materialized view.
• Fix for data type "interval day to second" in static data.

Fixes

• OSC-1052: Fixed input string was not in the correct format and failed to update file from source control for indexes.
• OSC-1059: Fixed incorrectly displayed comment for a column with the clause "invisible".
• OSC-1058: Fixed incorrect reading of parentheses from expression in the scripts folder.
• OSC-1057: Fixed the difference in expression for index constraint.

Features

• New tab has been added in the project settings for editing credentials to the database.

Fixes

• Added new dependent library to Source Control for Oracle installer.
• Materialized view log WITH PRIMARY KEY fixed scripting.

Fixes

• OSC-1033: Fix for setting up object locking for Oracle 12c and higher.
• OSC-826: Fix for downloading objects for the LOCK tab depending on the user's privileges.
• OSC-1041: Fix for Parallel keyword write/read correctly from script folder/svn/git repository.
• OSC-1034: Fix for check constraints comparison for TYPE columns.

Fixes

• Fixed a problem that caused the update client library to not be upgraded correctly.

Features

• Preview Advance Queuing (Queue and Queue Table objects) available to try (feature flag toggle required).

Fixes

• OSC-1022: Changes to Ignore Rules - now you can enable it if there are no conflicts.

Fixes

• OSC-1005: Changed how credentials are verified when connecting to the TFS repository on Azure DevOps.
• OSC-1035: Problem with connection to a TFS repository when user name contains a comma fixed.

Fixes

• OSC-1010: Problem with replacing alternate quoting fixed.

Fixes

• OSC-1013: Problem with missing "DatabaseInformation.xml" when it was deleted from the working folder fixed.
• OSC-970: Issue with filtering Public Synonyms using "Ignore Rules" option fixed.

Fixes

• OSC-1013: Problem with missing "DatabaseInformation.xml" file if it was deleted from working folder fixed.
• OSC-970: "Ignore Rules" properly filter Public Synonyms now.

Fixes

• OSC-1012: Option "ignore whitespaces" fixed.
• OC-1063: Population nested tables columns with "Ignore: dependent object in other schemas" option disabled fixed.