Released: Nov 14, 2024

Aggiornamenti in V7.0.249

Correzioni

• Resolved a parsing issue where SQLCMD commands were treated as procedure names, leading to the use of incorrect parsing logic.
• Fixed an issue that occurred when processing queries containing JOIN clauses.

Released: Oct 18, 2024

Aggiornamenti in V7.0.210

Funzionalità

• Improved the activation behavior of the Data tab in 'SQL Document'.
• Added Syntax Check in Object Editor for procedures and functions.
• Improved the display of object lists in text tooltips.
• Improved the handling of delimiters during object script generation.

Correzioni

• Fixed an issue that caused dbForge Studio for SQL Server to freeze when parsing expressions with multiple nested function calls.
• Fixed an issue that occurred when working with revision files that have spaces in their...

Released: Sep 5, 2024

Aggiornamenti in V7.0.158

Funzionalità

• T-SQL Code Analyzer
  • Updated T-SQL Code Analyzer with new rules.
• Connectivity
  • Renamed the Azure Active Directory authentication type to Microsoft Entra ID.
  • Added support for ApsaraDB.
• DevOps and CLI Automation
  • Added support for Atlassian Bamboo Data Center.
  • Added CLI automation for Find Invalid Objects.
  • Added Save Command Line for Index Manager.
  • Added support for generating comparison reports from the command line.
• Code Completion
  • Added support for non-aggregated columns in GROUP BY...

Released: Apr 12, 2024

Aggiornamenti in V6.6.5

Funzionalità

• Added integration support for Microsoft SQL Server Management Studio (SSMS) 20.x.

Correzioni

• Fixed an error associated with importing data from JSON.
• Fixed an issue that occurred when comparing text source objects in Source Control.

Released: Dec 28, 2023

Aggiornamenti in V6.5.140

Funzionalità

• Added support for the CREATE TABLE AS SELECT statement in Azure Synapse.
• Improved the parsing of the Output Clause in DML statements.
• Enhanced the functionality of the Paging Mode in the Data Editor Card View.
• Improved the behavior of the restoration of the Template Card settings in the Data Editor Card View when re-executing a SELECT query.
• Improved the behavior of the Enclose identifiers within square brackets option when generating triggers.
• In Source Control, DDL object...

Released: Jul 12, 2023

Aggiornamenti in V6.5.16

Funzionalità

• Added support for the GENERATE_SERIES and OPENQUERY relational operators.
• Added support for the following functions: LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, and SET_BIT.
• Added support for the APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC aggregate functions.
• Added support for the DATETRUNC function.
• Optimized the process of describing script folders.
• Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor.
• Improved reading of JSON...

Released: May 12, 2023

Aggiornamenti in V6.4.124

Funzionalità

• Added support for Data Manipulation Language (DML) trigger sorting in Source Control.
• Added syntax support for calling procedures/functions without the EXEC/EXECUTE keyword.
• Added support for the EXEC command in Syntax Check.

Correzioni

• Fixed an issue with locking the user interface when switching between SQL Document windows.
• Fixed an issue that occurred when displaying the informational window.
• Fixed an issue with the text search across DDL objects in Object Search.
• Fixed an error...

Released: Dec 30, 2022

Aggiornamenti in V6.4.7

Funzionalità

• Optimized resource consumption when preparing Quick Info and Code Completion hints.
• Added support for Apple macOS and Linux via CrossOver.
• You can now open Objects Filter window when creating a Schema Compare document.
• Added support for modifying view comments in Object Editor.
• Added disk folder cleanup in Source Control.
• Set object filter file from the CLI (command line interface) in Schema Compare.
• Improved Code Completion on MFA connections.
• Improved behavior of Ctrl+C/Ctrl+X...

Released: Sep 12, 2022

Aggiornamenti in V6.3.9

Funzionalità

• Microsoft SQL Server 2022 - Added support for:
  • 'ALTER DATABASE SCOPED CONFIGURATION'.
  • 'ALTER INDEX'.
  • 'ALTER TABLE'.
  • 'CREATE CLUSTERED INDEX'.
  • 'CREATE INDEX'.
  • 'CREATE TABLE'.
• Added query hints for 'DELETE', 'INSERT', 'SELECT', 'UPDATE' and 'MERGE' statements.
• Added support for 'BACKUP SYMMETRIC KEY' syntax construct.
• Added support for 'RESTORE SYMMETRIC KEY' syntax construct.
• Added support for 'DATE_BUCKET' function in Completion List, Quick Info and Parameter Information.
• Source...

Released: Jul 20, 2022

Aggiornamenti in V6.2.52

Correzioni

• Fixed an error that occurred when displaying database schema synchronization script.
• Fixed an error that occurred when switching between the pages of the Link Database to Source Control wizard.
• Fixed an error that occurred when connecting to the Azure server.
• Fixed an issue with hinting objects in the CROSS APPLY context.
• Fixed an issue with generating a Scripts Folder.
• Fixed a false positive syntax check error.
• Fixed an unexpected exception that occurred when dragging and dropping...