Released: Nov 3, 2023

V10.0.46 での更新項目

機能

• Source Control
  • Integrated Source Control with support for popular version control systems such as Azure DevOps Server, Apache Subversion (SVN), TFVC, Git (including GitHub, GitLab, and Bitbucket), Mercurial (Hg), Perforce (P4), and SourceGear Vault.
• Code Completion & Syntax Check
  • Added highlighting and quick navigation between syntax pairs.
  • Navigation between COLUMNS and VALUES in INSERT statements has been made easier, and has also been augmented with highlighting.
  • Improved the behavior of highlighting within INSERT statements in case of mismatches in VALUES.
  • Added support for the JSON_TABLE() table function in MariaDB.
  • Added support for JSON datatype parameters in stored procedures and functions.
  • Improved commenting out selections inside a line of code.
  • Added support for expressions when creating indexes.
  • Added support for ASC | DESC for indexes with functional key parts.
  • Added a new snippet ssf in addition to sel.
  • Added support for an INVISIBLE attribute in CREATE TABLE and ALTER TABLE statements.
  • Added support for FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME in CREATE USER statements.
  • Added support for ENCRYPTION in CREATE TABLESPACE and ALTER TABLESPACE statements.
  • Added support for UNDO TABLESPACE statements.
  • Added support for AUTOEXTEND_SIZE in CREATE/ALTER TABLE and CREATE/ALTER TABLESPACE statements.
  • Added IDENTIFIED BY RANDOM PASSWORD to CREATE USER and ALTER USER statements.
  • Added full support for complex VALUE statements.
  • Improved the behavior of the FOR ... END FOR statement.
  • The CAST() function now supports the AT TIME ZONE operator.
  • Non-aggregated columns are now suggested for GROUP BY statements.
  • The Reset Suggestions Cache and Refresh Local Cache buttons on the toolbar have been replaced with a single button called Reset Suggestions.
• Database Design
  • Added support for easily duplicating database objects and migrating them to a different server and added an option to drop the destination object.
  • All tables, views, and containers on database diagrams are now semitransparent, and all the interrelations are perfectly visible.
  • Added a few skins for diagrams and improved the zooming behavior.
  • Added the Clear Waypoints option that eliminates all the waypoints created for a specific relation. The relation gets restructured and shown in its default condition.
• Schema Compare
  • Added support for Source Control as the Source Type and Target Type in the comparison wizard, specify the required repository, and compare different revisions.
  • Added the option to enable/disable the display of DDL differences for pairs of compared objects with the Equal status.
  • Introduced a new group of comparison options called Sequences, which includes Ignore CACHE, Ignore CYCLE, Ignore INCREMENT BY, Ignore MAXVALUE, Ignore MINVALUE, and Ignore START.
  • Improved the behavior of the Ignore Permissions option.
  • Added a new exit code 114 for invalid object filters.
  • The object description process now ignores folders with static data, which may contain large files and thus may affect the performance.
  • Added support for saving the .scomp comparison document directly from the comparison wizard.
• Data Compare
  • Added support for hiding empty columns from the grid that displays data differences.
  • In case there are NULL to NOT NULL mapped pairs, the synchronization wizard now has a new page called Issues where you can specify the conflict resolution behavior for potential sync issues.
  • Added the Ignore internal spaces option that allows comparing string data types while ignoring whitespaces located in the middle of a line.
  • Added support for saving the .dcomp comparison document directly from the comparison wizard.
• Find Invalid Objects
  • Added support for searching for invalid objects across all databases on the entire server.
  • The search for invalid objects can now be launched from the command line.
• Security Manager
  • Added a checkbox that allows you to quickly lock and unlock user accounts.
• Connectivity
  • Added support for the latest version of the Transport Layer Security (TLS) cryptographic protocol - v1.3.
• General Features
  • Added support for temporal tables in MariaDB. This table type allows maintaining historical versions of data and makes it possible to track changes in data over time.
  • Extended support for the INET6 data type, intended for the storage of IPv6 addresses.
  • Added support for spatial reference identifiers (SRID).
  • Added an option that enables the quoting of identifiers during script generation.
  • Added an option that clears existing folders from the command line.
  • Upgraded the Retrieve Data feature and renamed it to Select Top Rows.
  • Query Profiler now displays the entire information tooltip when you place the cursor over a SQL statement.
  • Tweaked the Do not highlight less than option for Query Profiler.
  • Reworked the filtering algorithm option that is applied when editing formatting profiles.
  • Added the option to add IF NOT EXISTS to CREATE statements in your deployment scripts.
  • Tweaked the display of filtered data in the Card View mode.
  • The Search Options algorithm in Options has been substantially improved.
  • Added the Insert new tabs to the right of existing tabs option on the Tabs and Windows tab in Options.
  • The Tabs and Windows tab has also been expanded with the Tabs Layout, Show tabs in multiple rows, and Close tabs with middle-click options.
  • Added the Include size of the Integer datatype in statements option, which enables/disables the display of the size of integer values in generated DDL statements.
  • Introduced the option to include named regions in all CRUD templates.
  • Improved the behavior of the /restore /treatwarningaserror command.
  • The Data Pump section of the Studio's Start Page now includes the Copy Databases feature.
  • To keep it consistent across all Devart tools, Execution History has been renamed to Query History.
  • For additional convenience, the Studio now keeps the user-defined layout of columns in Query History.
  • The application launch time is now displayed in the Output pane alongside the application launch timestamp.
  • The Standard edition can now be activated and deactivated from the command line using the /activate and /deactivate commands.
  • SSL/SSH connections are now available in the free Express edition of the Studio.
  • Improved the application startup time.
  • Improved Query Builder performance.
  • Improved data display for the JSON_OBJECT function.
  • The 'Retrieve Data' command has been renamed to 'Select All Rows' and its behavior has been improved.
  • Improved the data editing behavior for tables with INVISIBLE columns in Data Editor.
  • Improved the display of the date and time format in the Output window.
  • Significantly improved the behavior of connection management.
  • Improved the behavior of Schema Compare to alert users with an error message when duplicate indexes exist in project tables.
  • Improved visualization of table relationships in Query Builder involving functions in JOIN conditions.
  • Added support for COLLATE for user-defined functions of return type.

不具合の修正

• Resolved an issue with invoking the popup menu on Apple macOS.
• Fixed an issue with processing long strings in the SQL Editor.
• Resolved an application activation error.
• Fixed an error that occurred when working with relationships on the diagram.
• Resolved an issue that occurred when establishing an SSH connection to the server.
• The database server error text now includes the error code.
• Fixed a memory leak issue that occurred during debugging of a procedure with numerous SELECT statements.
• Fixed an issue with incorrect comments for table partitions.
• Fixed a Pivot Table error that occurred when closing the application.
• Resolved an issue with updating data cells for TIMESTAMP-type columns in Data Editor.
• Fixed the 'Illegal mix of collations' error that occurred when retrieving metadata from the database server.
• Fixed an error that occurred when editing data in Data Editor.
• Fixed an error that occurred when opening a data connection in SQL Document.
• Fixed an error that occurred when prompting for a connection password.
• Fixed an error that occurred when reading data from Microsoft Excel files during import.
• Fixed an error that occurred when editing INSERT ... VALUES expressions in Query Builder.
• Fixed an error that occurred when editing a script in SQL document.
• Fixed the issue with indentation that occurred when formatting BEGIN...END code blocks.
• Fixed an error that occurred when closing the Studio with incomplete operations in open documents.
• Fixed an error that occurred during the generation of a synchronization script when connected to AWS RDS for MySQL.