dbForge SQL Tools 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;

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.

New features

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

Now, every add-in and standalone tool it contains is compatible with SSMS 19 Preview 2, the latest preview release of SSMS.

Now, every add-in and standalone tool it contains is compatible with SSMS 19 Preview 2, the latest preview release of SSMS.

The main improvements focused on performance optimization, connectivity advancement, productivity growth, and coding speed optimization.

* Support for new functions, statements, and keywords
* Improved the behavior of data sorting in Data Editor
* Added the ability to resize the search text field in dbForge Search
* Added a warning when trying to save read-only files with the applied changes

The main improvements focused on performance optimization, connectivity advancement, productivity growth, and coding speed optimization.