dbForge Studio for SQL Server V6.0.237

Released: Feb 23, 2021

Aggiornamenti in V6.0.237

Funzionalità

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.

Correzioni

  • The "Arithmetic operation resulted in an overflow." issue is SQL Profiler.
  • Unexpected exception occurred when generating data via the command line.
  • The freeze when describing user database in Data Generator.
  • Bug during generation of data preview in Data Import.
  • Unexpected exception occurred during data generation for tables with circular dependencies.
  • Improved object search. When editing a search query, a new search occurred according to the previous query.
  • Changes to the Description field in the generated documentation were not saved in Documenter.
  • Unexpected exception was thrown when opening any execution plan saved in SQL Server 2012.
  • Display of controls in dark skin in the table editor.
  • Mapping settings when comparing data in backups.
  • Critical parsing error.
  • Error with displaying data in the Data Compare grid.
  • Critical error with mapping when opening the data compare document.
  • Error occurred in Comparison Wizard when connecting to TFS.
  • Incorrect parsing of the FUNCTION parameters.
  • Error with setting connection in the Script Folder creation form.
  • Initial values were missing for SEQUENCE when retrieving DDL.
  • Error with defining compatibility of the columnstore indexes when working with Azure SQL.
  • Error with parsing DDL script of objects containing brackets.
  • Script parsing error occurred.
  • Incorrect synchronization script was generated when setting IDENTITY for the NOT NULL column.
  • Data display in the Data Compare document.
  • Generation of CREATE and CREATE OR ALTER scripts.
  • Display of equal objects.
  • The Insert Semicolons menu item put semicolons in wrong places making the script invalid.
  • Incorrect behavior of the split/combined layout toggle when retrieving data for tables from Database Explorer.
  • Code Completion did not suggest columns for table aliases.
  • When selecting the dark color scheme and applying the dark mode in the Windows settings, the text in an SQL document remained black.
  • The Edit.GotoBeginEnd command was missing from shortcuts configuration table.
  • Possible critical error after printing an SQL document.
  • The Unexpected Object Already Exists errors were popping up frequently within the database objects editor.
  • The procedure script was reformatted unexpectedly when trying to modify the latest.
  • The multi-line string was incorrectly highlighted within an SQL document.
  • The toolbar customizations are lost after restarting the program.
  • The modify method for the XML data type was treated incorrectly by the syntax checker.
  • Possible critical error within text comparison module when comparing database schemas.
  • The FOR JSON clause was not allowed in the CURSOR statement.
  • It was impossible to select multiple lines at once within an SQL document.
  • The syntax checker did not accept user variables within the SEND statement.
  • The syntax checker did not accept the FORCESEEK hint with the brackets.
  • Items in the completion list were scrolled by pixels but not rows, thus it was impossible to use mouse wheel for navigation.
  • The formatter failed to process queries containing column aliases defined via the 'alias = column' syntax.
  • The Alt + R accelerator in the Find and Replace window did not work.
  • The JSON_QUERY was not recognized correctly by the syntax checker.
  • Incorrect statement was highlighted with the error marker when profiling specific statements.
  • The WHERE keyword was not highlighted in case the JOIN condition was incomplete.
  • Error with defining the server version in.
  • Error occurred when updating the values of the joined tables in Data Editor.
  • Behavior with the window focus when executing queries in SQL document is tweaked.
  • Error occurred when opening the Database Diagram file in the previous version.
  • The work of the Filter Editor window in Data Editor is tweaked.
  • Issue with connecting to the cloud Git repositories.
  • Error when working with a SEQUENCE with large values.
  • Formatting was disabled when generating the script objects script.
  • Error when executing SELECT queries with the FOR JSON clause.