Released: Sep 5, 2024
V3.0.1 버젼 업데이트
기능
dbForge Studio for SQL Server V7.0.158
- 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.
수정사항
dbForge Studio for SQL Server V7.0.158
- 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.