Released: Sep 23, 2025

Aggiornamenti in V2025.2.37

Funzionalità

• 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.
• dbForge Studio for SQL Server
  • Connectivity
    • Enhanced authentication capabilities for SQL Server when using Entra ID.
    • Added support for Microsoft Fabric.
  • Improvements
    • Implemented automatic data type selection for columns based on their names.
    • Added options in Query Builder to qualify column names with table or alias names.
    • Added full support for the OPENROWSET function in Syntax Check.
    • Expanded Azure SQL support to include partition functions, schemes, tables, columns, and indexes.
    • Added suggestion support for BEGIN ATOMIC WITH, displaying available languages after the LANGUAGE keyword.
    • Added focus on the search field after invoking the Find Column command in Table Editor.
    • Removed the warning when saving an object with no errors in the editor.
• dbForge Studio for MySQL
  • Connectivity
    • Added support for MySQL 9.4.
    • Added support for MariaDB 12.
  • Improvements
    • Implemented automatic data type selection for columns based on their names.
    • Added options in Query Builder to qualify column names with table or alias names.
    • Added support for fractional values in precision (decimal data type); the fractional part is discarded, and values are now treated as integers.
    • Reorganized system views (in information_schema) by moving them to the Views folder in Database Explorer.
    • Added support for parsing the 'not_auto' secondary engine.
• dbForge Studio for Oracle
  • Improvements
    • Implemented automatic data type selection for columns based on their names.
    • Added options in Query Builder to qualify column names with table or alias names.
    • Added support for JSON data type modifiers.
• dbForge Studio for PostgreSQL
  • Improvements
    • Introduced the Alias refactoring feature.
    • Added support for NaN values in the numeric data type in Data Editor.
    • Improved the file opening speed.
    • Improved document name generation to avoid conflicts with the names of existing open documents.
    • Removed the call to pg_backend_pid() between the START TRANSACTION and SET TRANSACTION commands.
    • Introduced caret position persistence upon document reload.

Correzioni

• dbForge Studio for SQL Server
  • Fixed an issue with expanding the history table node in Database Explorer.
  • Resolved an issue where the Data Viewer content was lost when switching focus between tool windows.
  • Disabled the IgnoreDefaultCollations option for Table Editor.
  • Included all role grants in the role creation script generated using Generate Script As in Security Manager.
  • Resolved an exception that occurred when displaying differences in Source Control.
  • Fixed the 'Invalid object name "sys.dm_exec_sessions"' error.
  • Fixed an issue with aliases in Query Builder.
  • Fixed the synchronization of masked columns.
  • Resolved the synchronization issue when restoring the history table.
• dbForge Studio for MySQL
  • Fixed comparison and synchronization of UTF8 CHARACTER SET on legacy MySQL Servers.
  • Fixed an issue with diagram rendering in Query Builder.
  • Fixed an issue where parameters disappeared in the procedure editor when changes were made.
  • Fixed an issue with aliases in Query Builder.
• dbForge Studio for Oracle
  • Fixed the Go to Definition functionality for packages and package bodies in Oracle.
  • Resolved an issue with the generation of JSON data types.
  • Resolved an issue where the Data Viewer content was lost when switching focus between tool windows.
  • Fixed code completion for synonyms.
• dbForge Studio for PostgreSQL
  • Resolved an issue with displaying script differences that occurred when Word Wrap was enabled.
  • Fixed an issue with the truncation of numeric values in Data Editor.