dbForge Studio for SQL Server V6.0.237

The DevOps Automation feature

• dbForge Studio for SQL Server now performs DevOps Automation. On the start page, in the DevOps tab, links have been added to install the following plugins:
  • Plugin for Jenkins.
  • Plugin for TeamCity.
  • Plugin for Azure DevOps.
  • Plugin for Bamboo.
  • PowerShell module helps organize database DevOps processes for your Microsoft SQL Server databases. It allows you to develop, source-control and safely automate the deployment of database changes using dbForge for SQL Server tools via the Microsoft PowerShell interface.

Connectivity

• Added Heroku Cloud connectivity support.
• Added the ability to display SQL Server version when testing connections.

Code Completion

• Column sensitivity classification information is now available in the completion list and Quick Info.
• Added support for the following functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT, PWDCOMPARE and MIN_ACTIVE_ROWVERSION.
• Added support for the following statements: GRANT ALTER ANY SECURITY POLICY, GRANT ALTER ANY SENSITIVITY CLASSIFICATION, GRANT ALTER ANY DATABASE SCOPED CONFIGURATION, GRANT ALTER ANY COLUMN MASTER KEY, GRANT ALTER ANY COLUMN ENCRYPTION KEY, GRANT EXECUTE ANY EXTERNAL SCRIPT, GRANT ALTER ANY EXTERNAL DATA SOURCE, GRANT ALTER ANY EXTERNAL FILE FORMAT, GRANT ALTER ANY EXTERNAL LANGUAGE, GRANT ALTER ANY EXTERNAL LIBRARY, GRANT ADMINISTER DATABASE BULK OPERATIONS and CREATE/ALTER/DROP EXTERNAL LANGUAGE for Microsoft SQL Server 2019.
• Expanded support for the PREDICT function for SQL Server 2019.
• Expanded support for CREATE USER for Microsoft Azure SQL Database.
• Expanded support for CREATE INDEX, CREATE EXTERNAL, ALTER DATABASE, ALTER TABLE, ALTER EXTERNAL LIBRARY, ALTER AVAILABILITY GROUP, DROP EXTERNAL RESOURCE POOL, DROP EXTERNAL LIBRARY and ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019.
• Added support for temporary tables suggestions.
• Added support for OPENJSON objects suggestions.
• Added support for properties suggestion for built-in metadata functions.
• Added support for prompting names for the USE HINT option.
• Added support for prompting time zones in AT TIME ZONE.
• Added support for displaying MS_Description for SQL Azure database objects.
• Added support for prompting objects in the context of DBCC SHOW_STATISTICS.
• Added new option suggestions for the ALTER DATABASE SCOPED CONFIGURATION statement.

Code Refactoring

• Added the ability to convert stored routine executions into a script.
• Added the ability to unwrap dynamic SQL into parameterized queries.
• Added the ability to find Invalid Objects to show if any objects are referencing other objects that have been dropped and no longer exist in the database.

Code Navigation

• Added the ability to jump between CASE/END.
• Added the ability to jump between BEGIN TRY/END TRY.
• Added the ability to jump between BEGIN CATCH/END CATCH.
• Extended INSERT Highlight Occurrences feature to show a popup with the column name in the values area.

Code Execution

• Added the ability to run a single script against multiple databases in parallel or serial mode.
• Added Execution Warnings to warn of UPDATE or DELETE statements without a WHERE clause as well as TRUNCATE and DROP statements.
• Added the ability to export execution history to CSV file format.

SQL Formatter

• Added new formatting profiles: Collapsed, Commas before, Compact, Extended, Indented, MSDN SQL, Right aligned and Stack compact.
• Added the ability to quickly select formatting profiles from the context menu of a SQL file.

Data Editor

• Added a Cached Updates Mode to defer posting updates to a later time.
• Added new Web view for Data Viewer.
• Unified display of DATE in the Results Grid and Data Viewer.
• Added the ability to customize colors for Data Viewer JSON view in the dark skin.
• Added the ability to export data from a data grid to CSV, XML, HTML and JSON formats.
• Added settings for exporting data from a data grid to CSV.
• Added the ability to copy data such as CSV, XML, HTML and JSON formats to the clipboard as well as to a file.
• Added a keyboard shortcut for the Apply Changes command.

Data Export/Import

• Improved exporting and importing data to Google Sheets.
• Output Settings tab has been added to Data Export Wizard.
• Information about the export format has been added to the Data Export Wizard header.
• Added the ability to remember the Save an Export Project checkbox value.

Schema Compare

• Redesigned Progress Window for schema comparison and synchronization.
• Added an in-place SQL Formatting option for the text compare control.
• Added a Pre/Post-scripts execution tab in Schema Synchronization Wizard.
• Added the ability to append a Timestamp to the File Name in Schema Synchronization Wizard.
• Colors for Modified, Added and Deleted blocks have been changed in the text compare control.

Data Compare

• Redesigned Progress Window for data comparison and synchronization.
• Added exclude newly added objects option in Data Compare Wizard.
• Added Ignore Whitespaces option in Data Compare Wizard.
• Added Tolerance Interval option in Data Compare Wizard.
• Added a Pre/Post-scripts execution tab in Data Synchronization Wizard.
• Added hide empty columns options for the Only in Source and Only in Target views of a Data Compare document.

Data Generator

• Redesigned Progress Window for data generation.

Documenter

• Improved auto-line-break of long headings.

Other improvements

• Improved Generate Script As for DML Commands.
• Access to SQL Designer from the context menu has been added.
• Search for options have been added.
• Improved the ability to remember the size of the column properties window.
• DevExpress controls have been updated to v20.
• Added new vector HiDPI skins.
• Description of the Schema Export options has been improved.
• Improved generation of data previews in the data generator for tables with composite indexes.
• An option to exclude versioned tables from comparison has been added.
• Improved generation of DDL script of a trigger for the Modify command in Database Explorer.
• Improved support for the SSDT folder structure in Script Folder and Source Control.
• Improved performance when displaying data with a large number of columns.