dbForge Studio for SQL Server full changelog

* AI Assistant: free Express edition, AI model selection, file attachments, instructions
* Code Refactoring: name qualification and wildcard expansion
* Added Last modified column to Schema Compare reports
* Added product activation via sign-in

* Improved Text Editor with scroll bar annotations, an option to automatically surround selections, and camelCase formatting for identifiers
* Added search to Database Diagram
* Added support for SSMS 22
* Refined UI/UX

* Added auto error submission from the Error List to AI chat for explanations and suggested fixes, and Web Search option for dbForge AI Assistant
* Added support for Microsoft Fabric
* Enhanced authentication capabilities for SQL Server when using Entra ID
* Refined UI/UX

* AI Assistant Integration
* Expanded set of rules in T-SQL Analyzer for SQL Server
* Support for dedicated and serverless SQL pools in Azure Synapse Analytics
* Refined UI/UX

* Added support for SQL Server 2025
* Supported integration with SSMS 21
* Supported compatibility with Windows Server 2025

Updated T-SQL Code Analyzer with new rules; Renamed the Azure Active Directory authentication type to Microsoft Entra ID; Added support for ApsaraDB; Added support for Atlassian Bamboo Data Center; Added CLI automation for Find Invalid Objects; Added Save Command Line for Index Manager; Added generation of comparison reports from the command line; Added support for non-aggregated columns in GROUP BY statements; Added support for viewing the MSDescription property for databases; Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements; Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements; Added support for the COLUMN MASTER KEY server object; Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID; Added support for the TERTIARY_WEIGHTS function; Extended support for the AVAILABILITY GROUP constructs; Support for Implicit Procedure Execution; Added the Show Ignored Differences option for schema comparison; Added a new shortcut ALT+(arrow down) that allows going to each subsequent difference in a schema comparison document; Added support for the ADD SENSITIVITY CLASSIFICATION command; Added a new Issues page in Schema and Data Synchronization Wizards; Added a new index option STATISTICS_INCREMENTAL; Added a new group of options called Sequences, comprising Ignore START WITH in sequences and Ignore MIN VALUE in sequences; Added new comparison options: Ignore MIN VALUE, Ignore START WITH, Ignore CYCLE, Ignore INCREMENT BY, and Ignore CACHE; Added support for XML and HASH indexes for Azure; Added support for the PERSISTED construct for table variables; Added a Hide empty columns button in the static data diff grid; Updated the design of database diagrams with new element skins, opacity controls, and linear zoom factor; Added a new option Clear Waypoints; Added a new option Select All Relations;

Integration support for SSMS 20.x

Added support for the GENERATE_SERIES and OPENQUERY relational operators;
Added support for the 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.

Added DML triggers sorting in Source Control; added the syntax support for calling procedures/functions without the EXEC/EXECUTE keyword; supported the EXEC command in Syntax Check (D115075).

Optimized system resources consumption when preparing the Quick Info and Code Completion hints
Support for macOS & Linux via CrossOver