Released: Sep 5, 2024

Mises à jour de V7.0.158

Fonctionnalités

• 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 and CLI Automation
  • Added support for Atlassian Bamboo Data Center.
  • Added CLI automation for Find Invalid Objects.
  • Added Save Command Line for Index Manager.
  • Added support for generating 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.
  • Added support for Implicit Procedure Execution.
• Schema Compare
  • Added the Show Ignored Differences option for schema comparison.
  • Added a new shortcut ALT+(arrow down) 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 Clear Waypoints option.
  • Added a new Select All Relations option.
• 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 'Open Data in Editor' option.
  • 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 Drop destination object option to the Duplicate Object.
  • Added support for 'Search Property Lists' in Azure SQL Database.
• Data Generator
  • Added a new option to Append timestamp to the file name in Data Population Wizard.
  • Added new shortcuts to facilitate searching 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 Check All and Uncheck All buttons 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.
• Other
  • Extended the retention period for executed SQL queries to 10 years.
  • Improved the functionality for loading the database documentation document when there is no connection.
  • Optimized the parser to reduce CPU load.
  • Optimized the algorithm for finding links between declared objects.
  • Changed the default setting for the Find and Replace functionality from "All Open Documents" to "Current Document".
  • Added a wait time for retrieving the list of columns.
  • Enabled renaming of table names when exporting data to Excel.
  • Updated shortcuts to match the SSMS schema.
  • Added support for selecting multiple files in the Restore wizard.
  • Enabled text editing for multi-line selections with the Shift+Alt shortcut.
  • Significantly improved performance when selecting table column checkboxes in Query Builder.
  • Added support for the ApplicationName parameter in server connection settings.
  • Expanded the list of conditions in the Filter Editor for string data types in Data Editor.
  • Added support for displaying External Login and External Group objects in the Security Manager Explorer.
  • You can now set the Append timestamp to the file name checkbox to be selected by default in the Data Export wizard.
  • Improved parsing of ORDER BY expressions in subqueries.
  • Improved the behavior of the Round float types up to X digits option.
  • Added support for selecting quoted identifiers with a double-click.
  • Added support for Backup, Restore, and Attach Database operations from removable media.
  • Changed the data output for reports in Data Compare-reports now include original values without quotes and formatting.
  • Optimized schema description in Data Compare-non-schema-bound views are now read only when the Compare views option is enabled.

Correctifs

• Fixed the display of the database node icon in the Database Explorer.
• Fixed the shortcut behavior for the Results as Text functionality.
• Fixed an error that occurred when editing a query using the Data Report functionality.
• Fixed an error that occurred when opening the context menu on the Constraints tab of the Table Editor.
• Fixed the shortcut functionality for activating SQL Document views.
• Fixed the functionality for restoring open documents when changing the product edition.
• Fixed the functionality for comparing string data containing the backslash character.
• Fixed the behavior of the Go To Definition functionality when using an Azure AD MFA connection.
• Fixed internal application error.
• Fixed the Query History error that occurred after importing application settings.
• Fixed an issue with reading old snapshots: the synchronization script now executes correctly, ensuring databases are equal after comparison.
• Fixed the display for user datatypes in Database Explorer for the User_Data_Type_Name (Native_Type) columns.
• Fixed the error report during data export using ODBC when the ODBC connection is closed.
• Fixed the behavior of formatting via the command line that differed from the formatting in the SQL document due to an unknown ansi_quotes state.
• Fixed the parsing of functions with the GROUPING expression.
• Fixed a search error in the Source Control functionality.
• Fixed the display of the number of mapped columns on the Table Mapping page of the Schema Comparison Wizard.
• Fixed an issue with parsing JOIN expressions.
• Fixed the error report during data export via command line using ODBC when the ODBC connection is closed.
• Fixed data export via ODBC for existing tables.
• Fixed an issue preventing the deletion of the import file after import.
• Resolved the error report issue in the Database Documenter.
• Fixed the display of warnings in the Plan Diagram functionality.
• Fixed the Failed to perform the syntax action error.
• Fixed the error report during data export via command line using ODBC when the ODBC connection is closed.
• Fixed data export via ODBC for existing tables.
• Fixed the construction of queries with JOIN expressions in the Query Builder.
• Fixed data import from CSV files.
• Fixed an error that occurred when displaying External Data Source objects in the Object Viewer.
• Resolved issues with matching the output to the JSON format in data export.
• Fixed the display of table properties for Azure servers in Documenter.
• Fixed the error accessing the sql_expression_dependencies view with restricted user permissions in Source Control.
• Fixed the occasional error updating commands in SQL Document.
• Fixed the error retrieving metadata for server objects in Source Control.
• Resolved the issue with large or boundary values for Sequences properties.
• Fixed the occasional error in the Object Search functionality.
• Fixed the parser error for view definitions with a large number of JOINs.
• Improved DDL object comparison - the Ignore white spaces option no longer affects literal comparisons.
• Fixed an issue that caused custom server connection locations to reset in the Database Explorer.
• Resolved an issue with extra blank lines appearing in DDL when committing procedures and functions in Source Control.
• Resolved an issue with describing server objects in Source Control.
• Addressed the Execution Timeout Expired error that occurred during query execution.
• Fixed an issue with renaming indexes in the Database Explorer and Object Editor.
• Addressed the issue with incorrect data editing locks in Data Editor.
• Resolved an issue with dependency search for views that contain the PIVOT clause in the SELECT statement.
• The Disable check constraints option now respects server restrictions and no longer removes NOT NULL from columns where it is restricted.
• Fixed an issue with the synchronization button being inactive when the Comparison toolbar was hidden.
• Fixed the shortcut functionality for the GoToBraceExtend command.
• Fixed the object suggestions in the Completion List for large queries.
• Resolved an issue with renaming objects in SQL Azure Database.
• Fixed an error that occurred when describing the schema during script folder creation.
• Fixed an issue with extended properties missing N prefixes for Unicode values.