SQL Navigator 8.1 is now available!

SQL Navigator
1

Hi everyone,

We are pleased to announce the GA of SQL Navigator 8.1!

For all existing customers, SQL Navigator 8.1 contains new fixes and enhancements.

Enhancements:

  • Support of Oracle 23c/26ai

  • Support of latest patches of Windows 11, Windows Server 2022, and Windows Server 2025.

  • Team coding with support of Azure DevOps Services (TFVC), Microsoft Azure DevOps Server

Release notes:
https://support.quest.com/sql-navigator-for-oracle/8.1/technical-documents

Download:
https://support.quest.com/sql-navigator-for-oracle/8.1/download-new-releases

Bug Fixes

  • Users experience refresh issues in Team Coding when multiple database users attempt to simultaneously check out and check in the same package.

  • When comparing contents in the Team Coding Manager Revision History using SQL Navigator on Azure DevOps 2022, SQL Navigator displays the Error loading C:\users\DEWOLFFM\Appdata\local\temp\Nav7OESG error.

  • SQL Navigator is generating incorrect DDL statements for identity columns for primary key.

  • Code Assist (IntelliSense) does not fully support all DML statements. Issues occur particularly with nested DML statement aliases, especially in UPDATE queries, subqueries, and when using grouping functions such as SUM, MAX, and others.

    Users are unable to export query result table data to the latest Excel file format (.xlsx).

  • TFS Team Coding restricts users from entering more than 255 characters in the comment box during object check-in and check-out. When the character limit is exceeded, SQL Navigator displays the warning message: Maximum 255 characters allowed.

  • When users select specific schema options (rather than Select All) while checking in objects through TFS, SQL Navigator checks in all items regardless of the selections made in the dialog.

  • Users are unable to manually remove the time component from a date field in the editor. The time value can only be cleared through the GUI menu, not by typing directly into the field.

  • When users check out the package specification from SVN, both the package specification and body are locked, whereas only the specification is expected to be locked. The same behavior occurs during check-in when unlocking the package specification.

  • In tables with multiple triggers, after editing and saving one trigger, opening another from the DB Navigator may display the previously edited trigger instead of the selected one.

  • When users execute a SELECT query with an ORDER BY ASC clause on a date column and then switch to another tab, SQL Navigator does not retain the ORDER BY statement.

  • Users are unable to update records through the grid interface (F2) when working with Oracle tables that use double quotes in field names. If the query involves tables with double-quoted fields, record updates via the grid result UI do not function as expected.

  • After using the Find and Replace option, users are unable to manually replace text in the editor.

  • Objects or tables updated in the database are not reflecting in the VCS repository, even after creating a new revision.

  • The following options are not enabled in SQL Navigator under the Team Coding menu:

    Add file, Check Out, Check In, and Undo Checkout.

  • SQL Navigator generates a query with an incorrect format for the Get Metadata script in the Editor tab.

  • When using SQL Navigator to generate stubs while executing a function from a package, the output generated from Oracle 12c differs from that generated from Oracle 19c.