dbForge Studio for SQL Server V7.0.158

Released: Sep 5, 2024

Atualizações na V7.0.158

Recursos

  • 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.

Correções

  • 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.