dbForge Studio for SQL Server full changelog

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

The update delivers support for SQL Server 2022 Community Technology Preview 2.1 (CTP 2.1) alongside extended keyword suggestions and newly supported syntax constructs.

*Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
*Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function

DevOps Automation Features

DevOps Automation Features

New Object filter for Schema Compare
Redesigned data comparison report in CSV
Redesigned schema comparison report in HTML