Released: Jun 16, 2025

V2025.1.124 での更新項目

機能

• Added an AI Assistant that supports the following:
  • 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.
• 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.

dbForge Studio for SQL Server

• Connectivity:
  • Added support for dedicated and serverless SQL pools in Azure Synapse Analytics.

T-SQL Analyzer

• Expanded the set of rules.

dbForge Studio for Oracle

• Added support for parsing the JSON_OBJECT function and improved expression boundary detection in queries with syntax errors to enable correct execution of the Execute Current Statement and Format Current Statement commands.
• Restored the Execute command for Oracle procedures and functions.

dbForge Studio for PostgreSQL

• Connectivity:
  • Added support for PostgreSQL 18.

不具合の修正

dbForge Studio for SQL Server

• Restored the assignment of aliases to columns in SELECT statements generated using Studio for SQL Server.
• Fixed formatting issues for the AT TIME ZONE expression.
• Fixed incorrect placement of syntax error indicators.
• Fixed an issue where the snippet list appeared empty.
• Fixed a parsing error in the CREATE TABLE LIKE statement.
• Fixed parsing of keywords that support quoting.
• Fixed the "Unique key is missing" error for case-insensitive table names.
• Fixed data type conversion during data export: conversion now occurs only when necessary.
• Fixed dependency search for table types and user-defined data types.
• Fixed the "Incorrect syntax near the keyword 'WHERE'" error that occurred when selecting a filter in the Data Editor.
• Fixed export to Excel for the SqlMoney data type.
• Resolved issues related to suboptimal access to the Windows clipboard.
• Fixed an issue where the window layout was reset to defaults, requiring a restart after each reactivation.
• Improved the Table Editor to correctly handle foreign key dependencies from other tables when building Script Changes.
• Resolved an issue with reading foreign keys across schemas, enabling correct suggestions in Code Lookup (CL).
• Fixed the "Object reference not set to an instance of an object" error.

dbForge Studio for MySQL

• Now, selecting text enables the use of the Execute current statement command.
• Fixed a variable parsing issue that prevented database comparison in Schema Compare.
• Updated the document opening logic to ignore the Ping Interval command-line parameter when searching for existing connections.
• Fixed comparison and synchronization of default values for binary-typed columns.
• Fixed parsing issues with numeric types in the CAST function, LIMIT expressions in GROUP_CONCAT, and aliases that start with digits.
• Fixed comparison and synchronization of default collations and character sets.
• Fixed an issue that caused function comparisons to fail when the Ignore Whitespaces option was enabled.
• Fixed an error that occurred during the synchronization of column default values.
• Fixed an error that occurred when comparing foreign keys.
• Corrected parsing of variables in Oracle functions and procedures.
• Fixed an error in detecting data types that occurred when building models from SQL scripts.
• Resolved errors in object editors that occurred when working in the Oracle mode.
• Fixed an error that occurred when applying filters in the Data Editor.
• Fixed object search within procedures and functions.
• Resolved an error that occurred when reading backup files.
• Corrected checkbox behavior in the Options dialog of Schema Compare.
• Fixed an unexpected inclusion of int(11) in procedure definitions.
• Resolved an error report triggered by pasting the CREATE USER statement.
• Fixed the "Describe models failed! Reader: Views" error.
• Fixed the "Object reference not set to an instance of an object" error.
• Addressed synchronization issues that occurred when comparing signed and unsigned columns.
• Improved the activation error message to clearly indicate that the selected version cannot be activated due to an expired support and update period.
• Added missing elapsed time display during comparison progress.
• Fixed the display the BINARY data type in the data grid.

dbForge Studio for Oracle

• Fixed an issue with editing parameters in queries.
• Resolved an issue that caused dbForge to fail when connecting to Oracle instances via a proxy user.
• Resolved the "ORA-00933: SQL command not properly ended" error that occurred when using the Find Object feature.

dbForge Studio for PostgreSQL

• Fixed an issue where materialized view columns were not displayed in the Database Explorer.
• Fixed the loss of quotes when dragging objects from the Database Explorer into a document.
• Improved query error handling to suppress intrusive message boxes during the initial load and incremental suggestion updates.
• Resolved issues with row selection in SQL Editor.
• Resolved incorrect parsing of geometry types with dimensions that caused the affected columns to not appear in Database Explorer.