dbForge Studio for SQL Server v7.0 release notes

Last modified: May 28, 2025

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 & CLI Automation

• 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

Code Completion

• 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 suggestions for Implicit Procedure Execution

Schema Compare

• Added the Show Ignored Differences option for schema comparison
• Added a new shortcut ALT+↓ 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

Source Control

• 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

Database Diagrams

• 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

SQL Query History

• 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

Documents

• Added options to rearrange tab opening order
• Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
• Added a new option Open Data in Editor
• Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code

Database Explorer

• Added the ability to save filter settings for tables in Database Explorer to a file
• Added a new option Drop destination object to Duplicate Object
• Added support for Search Property Lists in Azure SQL Database

Data Generator

• Added a new option Append timestamp to the file name in Data Population Wizard
• Added new shortcuts to facilitate search for the required tables and columns

Script Generation

• Added automated wrapping of CRUD templates into named regions
• Added new options to Generate Scripts: Script DML triggers, Script security permissions, and Script authorization

Data Editor

• Added an option to set a cell value to a unique identifier from the shortcut menu

Pivot Tables

• Upgraded Chart Designer to a more advanced version with an improved appearance

Find Invalid Objects

• Added new buttons Check All and Uncheck All to facilitate selection of databases

Search

• Implemented export of search results to CSV

Index Manager

• Implemented a shortcut menu to help quickly arrange, sort, group, and filter entries in the grid

Application Startup Time

• Added application startup duration to be displayed alongside the startup timestamp