| Version | Change log |
| dbForge SQL Complete 7.0 Sep 5, 2024 | Introduced the Enterprise Edition of SQL Complete with T-SQL Code Analyzer; Added integration support for Microsoft Visual Studio 2022; Added integration support for Microsoft SQL Server Management Studio 20.2; 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; Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button; Added the ability to save user-defined column layouts in Query History; Added CLI automation for Find Invalid Objects; Added Save Command Line for Find Invalid Objects; Added Save Command Line for SQL Formatter Wizard; Support for Implicit Procedure Execution |
| dbForge SQL Complete 6.16 Apr 12, 2024 | Integration support for SSMS 20.x |
| dbForge SQL Complete 6.15 Jul 12, 2023 |
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. |
| dbForge SQL Complete 6.14 Dec 30, 2022 |
Support for SSMS 19 Preview 4 Columns suggestion in the ORDER clause for the CREATE CLUSTERED INDEX statement |
| dbForge SQL Complete 6.12.6 Sep 12, 2022 | 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. |
| dbForge SQL Complete 6.11 Jun 24, 2022 |
*SSMS v19 Preview 2 integration is added *Fixed an application error that occurred when starting SSMS 2014 *Fixed the display of data in Data Viewer when changing the order of columns in the Editor |
| dbForge SQL Complete 6.10 Apr 4, 2022 |
*CONSTRAINT suggestion support for ALTER TABLE statement *Suggestion of UPDATETEXT *DISTRIBUTED_AGG support for SELECT-GROUP BY *ALTER/DROP DATABASE SCOPED CREDENTIAL support *Support of Configuration Options for Query Store feature for ALTER DATABASE |
| dbForge SQL Complete 6.9.16 Oct 5, 2021 |
*CONSTRAINT suggestion support for ALTER TABLE statement *Suggestion of UPDATETEXT *DISTRIBUTED_AGG support for SELECT-GROUP BY *ALTER/DROP DATABASE SCOPED CREDENTIAL support *Support of Configuration Options for Query Store feature for ALTER DATABASE |
| dbForge SQL Complete 6.8.13 Jun 16, 2021 |
* Support for WITH INLINE for CREATE OR ALTER FUNCTION * Support of APPROX_COUNT_DISTINCT * Support of ALLOW_BATCH_MODE |
| dbForge SQL Complete 6.7 Feb 3, 2021 | Improvements focused on supporting the commands that strengthen the security of sensitive data in the databases, optimizing performance, maximizing productivity, and accelerating the coding process. |
