Released: Jun 17, 2022

Updates in V6.2.22

Features

• Added support for new functions in 'Completion List', 'Quick Info', and 'Parameter Information': GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID.'
• Added support for the FORMATFILE_DATA_SOURCE parameter for 'bulk_options' in OPENROWSET function.
• Improved support for the comparison of Microsoft SQL Server 2014-2019 backup files.
• Improved server connection behavior to avoid blocking connected databases.
• Improved behavior of wildcard-aided searches in a Schema Compare document.
• Improved display of object type list in the filter window of a Schema Compare document.
• Improved grid display in Monitor documents.
• Improved logic of column width auto-adjustment in Data Editor.
• Improved diagnostics of false syntax errors in Query Builder.

Fixes

• Fixed an issue that occurred when launching schema comparison.
• Fixed the performance of the source control update operation.
• Fixed an issue that occurred when working with static data in source control.
• Fixed an issue with the formatting of spatial data types.
• Fixed a text editor issue.
• Fixed an issue that occurred when closing the application.
• Fixed an issue that occurred when comparing data.
• Fixed an index synchronization issue.
• Fixed the performance of the commit and push operations in source control.
• Fixed an issue that occurred when changing the database in a SQL document.
• Fixed a command-line editor issue.
• Fixed an issue with displaying a container header on a diagram.
• Fixed a documentation generation issue.
• Fixed an issue with displaying text comparison differences.
• Fixed an issue that occurred when working with the file system.
• Fixed an issue with displaying nodes in Database Explorer.
• Fixed a data generation issue.
• Fixed an issue that occurred when working with transactions during schema synchronization.
• Fixed an issue with the installation package.
• Fixed an issue with document generation for encrypted procedures and functions in Documenter.
• Fixed an icon display issue in the Monitor document.
• Fixed a log file initialization issue that occurred when opening the application.
• Fixed an issue with the CONTRACT permission type in Security Manager.
• Fixed an issue with the search and replacement of values in Data Editor.
• Fixed an issue with creating a foreign key on a database diagram.
• Added the capability to control the column width for text data in Profile Server Events.
• Fixed a data filtering issue in Data Editor.
• Fixed an issue that occurred when opening Data Compare.
• Fixed the Close all unmodified command for object editors.
• Fixed an issue that occurred when opening a Monitor document.
• Fixed an unexpected exception that occurred when copying data to clipboard.
• Fixed an application uninstallation issue.
• Fixed an unexpected exception that occurred when creating data reports for non-SELECT scripts.
• Fixed an unexpected exception that occurred when building dependencies for Queue objects while generating documentation.
• Fixed an unexpected exception that occurred when describing database objects during search.
• Fixed an unexpected exception that occurred when working under the Azure Active Directory connection.
• Fixed an issue with the interception of external exceptions by SQL Tools.
• Fixed an issue that occurred when performing Analyze Code for a script with NOCOUNT ON.
• Fixed an issue with the display of differences in the XLS comparison reports in Data Compare.
• Fixed an unexpected exception that occurred when generating HTML documentation.
• Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare.
• Fixed an unexpected exception that occurred when exporting data to the Excel format.
• Fixed an unexpected exception in Data Editor.
• Fixed an issue with defining columns in a script for Python Generator in Data Generator.
• Fixed an unexpected exception that occurred when describing databases with identical names for Schema and Assembly objects in Documenter.
• Fixed an issue with connecting a database to a version control system.
• Fixed an issue with reading data from the server when executing a script.
• Fixed false syntax errors.
• Removed an error report thrown upon switching to the Design tab in cases when the query contained syntax errors or was not supported by Query Builder.
• Fixed an issue that occurred when inserting a drop-down list element into the text.
• Fixed an issue with calculating the Parameter Info of a function that was referred to via a synonym.
• Fixed a script formatting issue.
• Fixed an issue that occurred when updating the database object cache for hints.
• Fixed an issue that occurred when loading SSMS extensions.
• Fixed the highlighting of the system statistical functions in SQL Editor.
• Fixed a text editor issue on the Windows Build 22567 or later.
• Fixed the behavior of the Parameter Info hint.
• Fixed the behavior of the Quick Info hint.
• Fixed an issue that occurred when working with the table editor.
• Fixed the display of data in the login_time and last_batch columns on the Sessions tab in Monitor.
• Fixed an issue that occurred when working with a data comparison document.
• Fixed an issue that occurred when selecting view columns from its query.
• Fixed an issue that occurred when viewing trigger dependencies in Database Explorer.
• Fixed an issue with loading an SQL script from a saved file to a document.
• Fixed an issue that occurred when analyzing differences in Queue objects while executing the Get Latest command.