dbForge Studio for SQL Server v6.0 release notes

Last modified: May 28, 2025

DevOps Automation

Now dbForge Studio for SQL Server takes part in DevOps Automation. On the start page, in the DevOps tab, added links to install the following plugins:

Plugin for Jenkins
Plugin for TeamCity
Plugin for Azure DevOps
Plugin for Bamboo
PowerShell module that helps with organizing database DevOps processes for your SQL Server databases. It allows you to develop, source-control, and safely automate the deployment of database changes by using dbForge for SQL Server tools via the PowerShell interface.

Connectivity

Heroku Cloud connectivity support
Display of the SQL Server version when testing connection

Code Completion

Column sensitivity classification information available in the completion list and Quick Info
Support for functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT, PWDCOMPARE, MIN_ACTIVE_ROWVERSION
Support for statement: GRANT ALTER ANY SECURITY POLICY
Support for statement: GRANT ALTER ANY SENSITIVITY CLASSIFICATION
Support for statement: GRANT ALTER ANY DATABASE SCOPED CONFIGURATION
Support for statement: GRANT ALTER ANY COLUMN MASTER KEY
Support for statement: GRANT ALTER ANY COLUMN ENCRYPTION KEY
Support for statement: GRANT EXECUTE ANY EXTERNAL SCRIPT
Support for statement: GRANT ALTER ANY EXTERNAL DATA SOURCE
Support for statement: GRANT ALTER ANY EXTERNAL FILE FORMAT
Support for statement: GRANT ALTER ANY EXTERNAL LANGUAGE
Support for statement: GRANT ALTER ANY EXTERNAL LIBRARY
Support for statement: GRANT ADMINISTER DATABASE BULK OPERATIONS
Support for statement: CREATE/ALTER/DROP EXTERNAL LANGUAGE for SQL Server 2019
Expanded support for the function PREDICT for SQL Server 2019
Expanded support for CREATE USER for Azure SQL Database
Expanded support for CREATE INDEX for SQL Server 2019
Expanded support for CREATE EXTERNAL LIBRARY for SQL Server 2019
Expanded support for ALTER DATABASE for SQL Server 2019
Expanded support for ALTER TABLE for SQL server 2019
Expanded support for ALTER EXTERNAL LIBRARY for SQL Server 2019
Expanded support for ALTER AVAILABILITY GROUP for SQL server 2019
Expanded support for DROP EXTERNAL RESOURCE POOL for SQL Server 2019
Expanded support for DROP EXTERNAL LIBRARY for SQL Server 2019
Expanded support for ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019
Temporary tables suggestion
OPENJSON objects suggestion
Properties suggestion for built-in metadata functions
Prompting hints names for the USE HINT option
Prompting time zones in AT TIME ZONE
Displaying MS_Description for SQL Azure database objects
Prompting objects in the context of DBCC SHOW_STATISTICS
New options suggestion for the ALTER DATABASE SCOPED CONFIGURATION statement

Code Refactoring

Converting stored routines execution into a script
Unwrapping dynamic SQL into parameterized queries
Find Invalid Objects to get to know if any objects are referencing objects that have been dropped and no longer exist in the database

Jump between CASE/END
Jump between BEGIN TRY/END TRY
Jump between BEGIN CATCH/END CATCH
Extend INSERT Highlight Occurrences feature to show a popup with the column name in the values area

Code Execution

Run a single script against multiple databases in parallel or serial mode
Execution Warnings to warn of UPDATE or DELETE statements without a WHERE clause as well as TRUNCATE and DROP statements
Export of Query History to the CSV file format

SQL Formatter

New formatting profiles introduced: Collapsed; Commas before; Compact; Extended; Indented; MSDN SQL; Right aligned; Stack compact
Quick select formatting profile from context menu of SQL file

Data Editor

Cached Updates Mode to defer posting updates to a table to a later time
New Web view for Data Viewer
Unified display of DATE in the Results Grid and Data Viewer
Ability to customize colors for Data Viewer JSON view in the dark skin
Export data from a data grid to the CSV, XML, HTML, and JSON formats
Settings for the export data from a data grid to the CSV
Copy data as CSV, XML, HTML, and JSON formats to clipboard as well as to a file
Keyboard shortcut for the Apply Changes command

Data Export/Import

Data Export/Import to Google Sheets
Output Settings tab is added to Data Export Wizard
Information about the export format is added to the Data Export Wizard header
Remember the Save an Export Project checkbox value

Schema Compare

Redesigned Progress Window for schema comparison and synchronization
In-place SQL Formatting option for the text compare control
Pre/Post-scripts execution tab in Schema Synchronization Wizard
Append Timestamp to the File Name option in Schema Synchronization Wizard
Colors for Modified, Added, and Deleted blocks are changed in the text compare control

Data Compare

Redesigned Progress window for data comparison and synchronization
Exclude newly added objects option in Data Compare Wizard
Ignore Whitespaces option in Data Compare Wizard
Tolerance Interval option in Data Compare Wizard
Pre/Post-scripts execution tab in Data Synchronization Wizard
Hide empty columns options for Only in Source and Only in Target view of Data Compare document